Code to see which button was pressed

[whatsmyname]

Hello again all,

I am trying to write a generic code that will see which button was pressed. I have been playing around with many different ways and I cannot seem to figure one out. I am assuming it is a If, Then statement but my lack of knowledge is hindering me.

Does anyone know of a simple code that will look to see which button was pressed?

Any help is appreciated.

Thank you.

[Jakobshavn]

Please Login or Register  to view this content.

[whatsmyname]

Thank you for that sample of code.

But I am trying to have the code figure out which command button that is on the worksheet was pushed and then change the command buttons caption.

Basically I have a worksheet with multiple command buttons on it. When the user clicks on one of the buttons a user form opens up and the user can input a date into a textbox and then notes into another textbox. Then when the user clicks on the "Save" button that is on the user form, the code looks to see which command button on the worksheet that was pushed that caused the user form to open and save the command buttons caption to the date that was entered into the first textbox.

I can upload a file if I need to.

Once again thank you all.

[Jakobshavn]

Here is an extremely simple example..................three buttons on a sheet..............all attached to the same macro.

The macro determines which button was pressed and changes the "caption" on that button

[whatsmyname]

Thank you sir. I can get it to work. I might be posting back because I have to do some modifications.

One thing I think I was doing wrong though was that I had activex buttons. So, with this code, I assuming that the application caller doesn't work with activex buttons. Is this correct?

I couldn't get it to at least.

[shg]

That's correct, it does not.

[Jakobshavn]

It is usually not an issue with ActiveX controls (at least for me), because each control has its own macro.

[whatsmyname]

Is there anyway that I can get this code to work with an activex button? Would I just put the code into each buttons code?

[whatsmyname]

Yeah, when I try to do it with an activex button it gives me the following error.

Is it a different caller method for an activex button?

[shg]

Application.Caller doesn't work for an ActiveX button. There is no direct alternative.

[whatsmyname]

Yeah, when I try to do it with an activex button it gives me the following error.

Is it a different caller method for an activex button?

[Jakobshavn]

I am attaching a workbook that has examples for the "other" kind of button