Populate TextBox with cell reference when cell is clicked while UserForm is open

Question

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.

Answer 1

There a control for this RefEdit available in the toolbox. Excellent article here to get you started ozgrid.com/Excel/free-training/ExcelVBA2/excelvba2lesson20.h‌​tm