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. :) |
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) |