Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can the caption of a (button) shape (not cmd) be changed from VBA
On Excel worksheets I use the button shape from the Forms toolbar and assign
macros. Properties exist such as Name and AlternativeText but I am unable to find a way to change what the user sees from VBA. There is no text, caption, label, etc. property. Since it can be edited manually it must be changeable from code, although it may require Windows API to accomplish it. Any suggestions? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can the caption of a (button) shape (not cmd) be changed from
The easiest solution (IMO) would be to change your buttons from Forms buttons
(shapes) to Control Toolbox Buttons (actual buttons with properties and methods). These buttons are easy to reference and have the all of the properties you require. It will be a bit of work, but it should not be too bad. The Code for these buttons will be embedded right in the sheet. You just need to add one line of code for each button to call your macros... -- HTH... Jim Thomlinson "AnExpertNovice" wrote: On Excel worksheets I use the button shape from the Forms toolbar and assign macros. Properties exist such as Name and AlternativeText but I am unable to find a way to change what the user sees from VBA. There is no text, caption, label, etc. property. Since it can be edited manually it must be changeable from code, although it may require Windows API to accomplish it. Any suggestions? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can the caption of a (button) shape (not cmd) be changed from
ActiveSheet.Shapes("nameofshape").Characters.text = "Your Text Here"
Nathaniel "AnExpertNovice" wrote: On Excel worksheets I use the button shape from the Forms toolbar and assign macros. Properties exist such as Name and AlternativeText but I am unable to find a way to change what the user sees from VBA. There is no text, caption, label, etc. property. Since it can be edited manually it must be changeable from code, although it may require Windows API to accomplish it. Any suggestions? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can the caption of a (button) shape (not cmd) be changed f
What is VBA anyway?
"Jim Thomlinson" wrote: The easiest solution (IMO) would be to change your buttons from Forms buttons (shapes) to Control Toolbox Buttons (actual buttons with properties and methods). These buttons are easy to reference and have the all of the properties you require. It will be a bit of work, but it should not be too bad. The Code for these buttons will be embedded right in the sheet. You just need to add one line of code for each button to call your macros... -- HTH... Jim Thomlinson "AnExpertNovice" wrote: On Excel worksheets I use the button shape from the Forms toolbar and assign macros. Properties exist such as Name and AlternativeText but I am unable to find a way to change what the user sees from VBA. There is no text, caption, label, etc. property. Since it can be edited manually it must be changeable from code, although it may require Windows API to accomplish it. Any suggestions? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can the caption of a (button) shape (not cmd) be changed from
Nathaniel,
Thanks! Possibly because I'm using Excel 2002 the format actually turned out to be. ActiveSheet.Shapes("nameofshape").TextFrame.Charac ters.Text = "testing" But that minor change was easy with your help. Jim, Thanks for responding, but having code embedded in the worksheet rather than a module is exactly what I prefer to avoid "Nathaniel Gibson" <Nathaniel wrote in message ... ActiveSheet.Shapes("nameofshape").Characters.text = "Your Text Here" Nathaniel "AnExpertNovice" wrote: On Excel worksheets I use the button shape from the Forms toolbar and assign macros. Properties exist such as Name and AlternativeText but I am unable to find a way to change what the user sees from VBA. There is no text, caption, label, etc. property. Since it can be edited manually it must be changeable from code, although it may require Windows API to accomplish it. Any suggestions? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can the caption of a (button) shape (not cmd) be changed f
Visual Basic for Application. A very nice programming language. The
simplest use would be for creating user functions. A more complex use would be for manipulating another application such as Access or Outlook. -- My handle should tell you enough about me. I am not an MVP, expert, guru, etc. but I do like to help. "Gee-off" wrote in message ... What is VBA anyway? "Jim Thomlinson" wrote: The easiest solution (IMO) would be to change your buttons from Forms buttons (shapes) to Control Toolbox Buttons (actual buttons with properties and methods). These buttons are easy to reference and have the all of the properties you require. It will be a bit of work, but it should not be too bad. The Code for these buttons will be embedded right in the sheet. You just need to add one line of code for each button to call your macros... -- HTH... Jim Thomlinson "AnExpertNovice" wrote: On Excel worksheets I use the button shape from the Forms toolbar and assign macros. Properties exist such as Name and AlternativeText but I am unable to find a way to change what the user sees from VBA. There is no text, caption, label, etc. property. Since it can be edited manually it must be changeable from code, although it may require Windows API to accomplish it. Any suggestions? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can the caption of a (button) shape (not cmd) be changed f
Thank you.
"AnExpertNovice" wrote: Visual Basic for Application. A very nice programming language. The simplest use would be for creating user functions. A more complex use would be for manipulating another application such as Access or Outlook. -- My handle should tell you enough about me. I am not an MVP, expert, guru, etc. but I do like to help. "Gee-off" wrote in message ... What is VBA anyway? "Jim Thomlinson" wrote: The easiest solution (IMO) would be to change your buttons from Forms buttons (shapes) to Control Toolbox Buttons (actual buttons with properties and methods). These buttons are easy to reference and have the all of the properties you require. It will be a bit of work, but it should not be too bad. The Code for these buttons will be embedded right in the sheet. You just need to add one line of code for each button to call your macros... -- HTH... Jim Thomlinson "AnExpertNovice" wrote: On Excel worksheets I use the button shape from the Forms toolbar and assign macros. Properties exist such as Name and AlternativeText but I am unable to find a way to change what the user sees from VBA. There is no text, caption, label, etc. property. Since it can be edited manually it must be changeable from code, although it may require Windows API to accomplish it. Any suggestions? |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can the caption of a (button) shape (not cmd) be changed from VBA
If it is a button from the forms toolbar, it does have a caption property.
However, you have to treat it as a button to use it. If you want to treat it as a shape: ActiveSheet.Shapes("Button 1").TextFrame.Characters.Text = "ABCD" but as a button it is ActiveSheet.buttons("Button 1").Caption = "ABCDEF" A button is a hidden object in the object browser, so if you right click on the browser and select show hidden members, you will be able to see the properties. Unlike Jim, unless there are special properties you need to work with, I don't see any reason to go to control toobox toolbar commandbuttons. -- Regards, Tom Ogilvy "AnExpertNovice" wrote in message ... On Excel worksheets I use the button shape from the Forms toolbar and assign macros. Properties exist such as Name and AlternativeText but I am unable to find a way to change what the user sees from VBA. There is no text, caption, label, etc. property. Since it can be edited manually it must be changeable from code, although it may require Windows API to accomplish it. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CURSOR SHAPE HAS CHANGED | Excel Discussion (Misc queries) | |||
Can Multiple Range Pivot Table's field button's caption be changed | Excel Discussion (Misc queries) | |||
my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
Cell comment boxes shouldn't change size/shape unless changed by u | Excel Discussion (Misc queries) | |||
Caption of a button | Excel Programming |