sorry, repeat question

  • Thread starter Thread starter ABC
  • Start date Start date
A

ABC

Hi,

I'm not trying to be a pain in the ass but I really need some help
here. I previously asked the following question:

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 (the cell with
the button on it) it was invoked.
How would I do this?

Someone responded by saying use ActiveCell.Address, the problem with
ActiveCell.Address is that it returns whatever cell is highlighted
when you press the button which isn't necessarily the address of the
form or command button that you pressed.

Does anyone have any other ideas?


Thanks in advance.

ABC
 
Back
Top