finding active cell

  • Thread starter Thread starter ABC
  • Start date Start date
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
 
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
 
Back
Top