This just has to be a no brainer, but can't find a solution.
All I want to do is click on a CommandButton in excel and get the name of the command button I just pressed pressed.
In access I would just use something like : Screen.ActiveControl.Name
I have tried things like:
Private Sub ClearDataLocGrp01_Click()
ButtonName = Application.Caller
But get an error = 2023 error from the Application.Caller line.
Also tried using a shape object, but can't figure it out. It's has to be easy.