finding active cell

A

ABC

I would like to use either a form button or a command button to
execute a macro that will launch a vba form. When the form is loaded
I would like to know from what cell in the spreadsheet it was invoked.
How would I do this?

Thanks

ABC
 
A

ABC

ActiveCell.Address will return whatever cell is highlighted on the
spreadsheet, which isn't necessarily the address of the form or
command button that you pressed

ABC
 

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