how to put the select range dialog box onto an excel vba form as a gui control

Vote count:

0

Some built in excel formulas and functions require you to select a range and they give you a gui control to do so.

How can incorporate one of these Range GUI controls into a VBA form to allow the user to select a range?

An example of this Select Range GUI control can be found on the Create New Formula Rule (for Conditional Formatting) below.

asked 36 secs ago

yoshiserry

187

how to put the select range dialog box onto an excel vba form as a gui control