RefEdit Control Element
The RefEdit Control Element is an Active-X Object, designed to help selecting cell ranges and obtaining them as text for use in other programs. The RefEdit Control Element is part of MS Excel.
XLplus uses this element in various dialogs to ease entering a cell or range. You can enter cells or ranges via keyboard alternatively. Indead, using the RefEdit Control Element is more convenient.
Add Zeros, for example, uses this to allow entering a user defined range, where to add characters.
Usage
You can insert text directly into the Element, place the cursor in it and select a cell or range from the active worksheet or, by clicking
start it explicitly.
Note: This guarantees a correct range information within the Control Element. In case you enter ranges manually, make sure to enter a correct cell reference.
Afterwards, select worksheet and range.
Now, you can select a worksheet from the Worksheets Tab ...
... and the required range of cells afterwards.
Go back to the previous dialog by :
Your data was taken over and is available for the program now.
XLplus checks returned data. In case the data is not a correct cell reference, a warning is given. You have to correct your input then. The easiest way doing this is using the Ref Edit Control the way described.
A correct cell reference consists of:
- (Optional:) Name of the Worksheet followed by !
- range of cells (either one cell or a range in A1 notation)
XLplus changes the cell reference style used to A1 notation every time a tool is launched which uses a RefEdit Control Element. After the tool finished, the original notation is used again. S. Toggle Cellreference Style.