Ref Edit Control

The RefEdit control is specific to forms created in Microsoft Excel, as it allows you to select a cell or a range of cells in a worksheet and pass it to your VBA procedure. You can see how this control works by taking a look at some of the built-in dialog boxes in Excel. For example, the Consolidate dialog accessed from the Data menu has a RefEdit control labeled Reference that lets you specify the range of data that you want to consolidate. To temporarily hide the dialog box while selecting a range of cells, click the button to the right of the RefEdit control. The second hands-on example in this chapter uses the RefEdit control to populate a list box with students' names.

0 0

Post a comment