Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign a Ribbon Control's Label from a Variable in VBA Code
Hi, everyone. I have a very simple question.
As the subject indicates, how do I assign a ribbon control's label from a variable in VBA Code? for example, I have a button declared as: <button id="Btn1" label="My button" onAction="File.xls!MyButtonAction"/ but instead, I want to get the label from the VBA code declared as: Public Const Btn1Label As String = "My button" Thanks in advance. :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign a Ribbon Control's Label from a Variable in VBA Code
Hi jean grey
Why not use Get Label, see http://www.rondebruin.nl/dynamic.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jean grey" wrote in message ... Hi, everyone. I have a very simple question. As the subject indicates, how do I assign a ribbon control's label from a variable in VBA Code? for example, I have a button declared as: <button id="Btn1" label="My button" onAction="File.xls!MyButtonAction"/ but instead, I want to get the label from the VBA code declared as: Public Const Btn1Label As String = "My button" Thanks in advance. :) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign a Ribbon Control's Label from a Variable in VBA Code
I don't think that you can, the controls are not exposed. But the callback
is invoked when the button is clicked, so you action it there. What are you trying to do? -- __________________________________ HTH Bob "jean grey" wrote in message ... Hi, everyone. I have a very simple question. As the subject indicates, how do I assign a ribbon control's label from a variable in VBA Code? for example, I have a button declared as: <button id="Btn1" label="My button" onAction="File.xls!MyButtonAction"/ but instead, I want to get the label from the VBA code declared as: Public Const Btn1Label As String = "My button" Thanks in advance. :) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign a Ribbon Control's Label from a Variable in VBA Code
Thanks, Ron. That was what I needed. :)
"Ron de Bruin" wrote: Hi jean grey Why not use Get Label, see http://www.rondebruin.nl/dynamic.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "jean grey" wrote in message ... Hi, everyone. I have a very simple question. As the subject indicates, how do I assign a ribbon control's label from a variable in VBA Code? for example, I have a button declared as: <button id="Btn1" label="My button" onAction="File.xls!MyButtonAction"/ but instead, I want to get the label from the VBA code declared as: Public Const Btn1Label As String = "My button" Thanks in advance. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign custom number format to the ribbon | Excel Discussion (Misc queries) | |||
Splitting up code ribbon | Excel Discussion (Misc queries) | |||
Alter ribbon button label on the fly? | Excel Programming | |||
How can I make Excel read a value from a textfile and assign it to a variable in my VBA code?? | Excel Programming | |||
[Q] Save As throws type mismatch error in control's code? | Excel Discussion (Misc queries) |