Difference between Forms_Button & ControlToolbox_Button

[harpreetgujral]

Hi,

What would be the procedure to change the caption of the command button created through Forms and Control Toolbox?

Example:
I created a Command Button on Sheet named data through the Forms Toolbar. I can use the following code to change the caption of the command button:

ActiveSheet.Shapes("CmdNavigation").Select
With Selection
.Caption = "Activate Navigation"
End With

However, how can we change the capion of a Command Button created through a ActiveX Toolbar?

Thanks for your suggestions

 

[Andrew Poulsom]

That would be:

ActiveSheet.OLEObjects("CmdNavigation").Object.Caption = "Activate Navigation"

 

[harpreetgujral]

Andrew,

If i have to change any property for any Active X Control, will i have to adopt a similar approach?

Thanks
Harry

 

[Andrew Poulsom]

You need to use the Object property for properties that aren't a member of OLEObject. See:

http://msdn.microsoft.com/en-us/library/aa221581(v=office.11).aspx