Accessing selected cell from modal dialog

G

Guest

Dear group

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

Kind regards

Jim...
 
C

Chip Pearson

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



message
news:[email protected]...
 
J

Juan Pablo Gonzalez

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top