Accessing selected cell from modal dialog

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear group

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

Kind regards

Jim...
 
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]...
 
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
 
You must log in or register to reply here.

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

Similar Threads

Error 400 in VB editor 3
Button on Userform calling GetOpenFilename 2
Code to kill all modal dialogs 1
Creating a Ribbon in XL2003? 9
Non-modal dialog tracking Ctrl+click'd selection 4
Make non-modal form an inactive window 2
Form slow to repaint after closing modal dialog 0
Addin interference 2

Back
Top