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