Rick, Thanks for your help on the previous question.
since you know just where I was coming from on that question, I'm tagging
this one on too.

When I press a CommandButton, is there a way to capture the caption
information of a command button that was just pressed and have it displayed
in, say AA1? I'd like this to happen without knowing which CommandButton
I'm pressing.

Range("AA1").Value= Pressed Command Button Caption

Is this possible?

Thanks,
Paul



--

"Rick Rothstein" wrote in message
...
See if this example gets you started...

Worksheets ("Sheet1")
X = 1
.OLEObjects("CommandButton" & X).Object.Caption = "First Button"
X = 2
.OLEObjects("CommandButton" & X).Object.Caption = "Second Button"
End With

--
Rick (MVP - Excel)


"PCLIVE" wrote in message
...
I'm using a CommandButton from the Control Toolbox. How can I access
this control via VBA using a Variable.

Example:
i=1

I have CommandButton1.

I'd like to set the caption of CommandButton1 use the "i" variable for
the number of that CommandButton. I've done this before with a button on
a UserForm using something like:

UserForm3.Controls("CommandButton" & i).Caption = "Test"

So how can I do this with a CommandButton that is not on a UserForm?

Thanks,
Paul



--