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