Well Im going mad....
I have a button on a sheet (Active X Command button) called CommandButton1
I want to set its caption via VBA however every method I can think of results in a "Run time error 438" object doesnt support this property or method.
Now Im fairly 99% sure Ive done this a dozen times in the past using
nope....![]()
CommandButton1.caption = "My caption"
nah....![]()
ActiveSheet.CommandButton1.caption = "My caption"
all giving the same error, come on folks, what daft thing am I doing wrong?![]()
ActiveSheet.OLEObjects("CommandButton1").Caption = "My caption" ActiveSheet.Shapes.CommandButton1.Caption = "My caption"











LinkBack URL
About LinkBacks
Register To Reply
Bookmarks