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