Ref Edit

The RefEdit control allows the user to select a range on a sheet; the range is returned as the value of the control. It can be added to any form. Once activated by a click of the button on the right side of the field, the userform disappears and is replaced with the range selection form, used when selecting ranges with Excel's many wizard tools. Click the button on the right to show the userform once again.

The form in Figure 21.5 and following code allow the user to select a range, which is then made bold:

Figure 21.5

Use RefEdit to enable the user to select a range on a sheet.

0 0

Post a comment