J June Jan 30, 2005 #1 I have an OLEOBject with a button in it. How can I change the caption of this in VBA?
B Bob Phillips Jan 30, 2005 #2 activesheet.oleobjects("CommandButton1").object.caption="Bob" -- HTH RP (remove nothere from the email address if mailing direct)
activesheet.oleobjects("CommandButton1").object.caption="Bob" -- HTH RP (remove nothere from the email address if mailing direct)
A Allison Jan 30, 2005 #3 Bob Thanks again for the response. My issue goes a little further in that the caption that I want to change is a button within the OLEObject. E.g. activesheet.oleobjects("CommandButton1").object.cmdButton.caption="Bob" Regards June
Bob Thanks again for the response. My issue goes a little further in that the caption that I want to change is a button within the OLEObject. E.g. activesheet.oleobjects("CommandButton1").object.cmdButton.caption="Bob" Regards June
B Bob Phillips Jan 30, 2005 #4 Do you want to pass that through me again? This is the object within the OLEObject. What exactly have you created? -- HTH RP (remove nothere from the email address if mailing direct)
Do you want to pass that through me again? This is the object within the OLEObject. What exactly have you created? -- HTH RP (remove nothere from the email address if mailing direct)
