sorry, repeat question

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
 

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

finding active cell 1
Access Automatically Send a notification email once a record is added 0
How to use multiple command button to copy user form data to multiple worksheet 0
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
'Cannot insert object' message when I try to put a button on a worksheet 7
Button that will increment by 1 2
FORM ENTRY OUTSIDE OF RANGE SPECIFIED 1
Moving between cells 2

Top