VBA Form

[Mark Soetens]

Hello,

Is there a kind of textbox property in VBA Userform, that allows an entry by selecting a cell or a range with the mouse?
I'm creating a macro that should allow information from a selected column or a range of cells, and instead of typing the column I was hoping it could be selected with the mouse.

Thanks,
Mark

 

[Andrew Poulsom]

The RefEdit control allows the user to select a range. It's the last one in the ToolBox (bottom left).

 

[Mark Soetens]

Thank you, that's precisely what I was looking for.