I am working on a small VBA project, part of it is a userform.
One of the TextBoxes on the form requires the user to provide a cell reference
While the UserForm is open, if the TextBox is currently selected, and user clicks on a cell in the workbook, I'd like the TextBox to be populated with a reference to that cell.
(the same way as for example "New Formatting Rule: Use a formula to determine which cells to format" formula input is done)
Is there any way of solving this?
Important: the macro is not workbook specific, so I can't put anything in Workbook_Open event etc.