Return a userdefined cell reference from a dialog
2000-02-05 Dialogs 2 233
If you want a user to respond with a cell reference in your custom dialog by selecting cells in a worksheet, you follow these simple steps:
- Insert a dialog sheet in the workbook
- Add an editbox for the cell reference
- Edit the properties for the editbox by doubleclicking it.
- In the properties dialog (Control-sheet) you can apply that the editbox is going to contain a cell reference
- Close the dialog.
In Excel97 or later you would use the RefEdit control instead of an EditBox control.