| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing selected cell from modal dialog
Dear group
How is it possible to access a selected cell from a modal dialog Kind regards Jim... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing selected cell from modal dialog
Jim,
I'm not entirely sure what your question is, but you can use the ActiveCell object to get the active cell, or the Selection object to get the entire range of selected cells. If only one cell is selected, then ActiveCell and Selection return the same thing. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jim McLeod" wrote in message ... Dear group, How is it possible to access a selected cell from a modal dialog? Kind regards, Jim... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Accessing selected cell from modal dialog
You mean, to let the user choose a cell ? if so, use the RefEdit control, if
you mean, look at the value of the active cell, use something like Dim MyValue As Variant MyValue = ActiveCell.Value -- Regards, Juan Pablo González "Jim McLeod" wrote in message ... Dear group, How is it possible to access a selected cell from a modal dialog? Kind regards, Jim... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Userform modal | Excel Discussion (Misc queries) | |||
| MS Dialog 5.0 sheets - Accessing data elements of objects | Excel Worksheet Functions | |||
| Forms that are modal in 97 are not modal in 2003 | Excel Discussion (Misc queries) | |||
| Controling a dialog box after I've selected the datasource | Excel Programming | |||
| Modal User Form | Excel Programming | |||
Linear Mode
