Accessing selected cell from modal dialog
 

Dear group

How is it possible to access a selected cell from a modal dialog

Kind regards

Jim...

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...

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...