Assign a Ribbon Control's Label from a Variable in VBA Code

  • Thread starter Thread starter jean grey
  • Start date Start date
J

jean grey

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. :)
 
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?
 
Back
Top