View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jean grey jean grey is offline
external usenet poster
 
Posts: 19
Default 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. :)