How to change button's properties

August 13, 2009 at 05:16:10
Specs: Windows XP
In Excel vba:
I want to change the button's text and ToolTipText according to a value that I know.
How do I get to the button's properties ?
What is the button's name ?
Thanks,

See More: How to change buttons properties

Report •


#1
August 13, 2009 at 07:31:51
There are many types of "buttons" in Excel.

Can you right-click the button and garner any information that way?


Report •

#2
August 13, 2009 at 11:08:33
In the right-click I have only design properties, but I don't see anywhere the name of the button. I can also change the text, but I want to change it in vba script, according a value.
How can I catch the bottun in vba script, to change his properties ?
Thanks,

Report •

#3
August 14, 2009 at 08:41:11
How can I catch the bottun in vba script, to change his properties ?
It depends on the button. In Office 2K, you have Excel's buttons, and ActiveX buttons. They might have added more button types in newer versions of Excel; I haven't been keeping track.

Report •

Related Solutions


Ask Question