Using a Variable value in a custom ribbon

[lukez]

Not sure if this is possible, I can't seem to figure it out.
I made a custom ribbon menu, which is stored in the Excel.officeUI file. For one of the button labels (or description) I would like to have it display a variable in a stored xla file. Is there a way to do something like:
variabletouse = "test123" in macro sub stored in macro.xla saved in c:/data/

Modifying the Excel.officeUI file for the button to be:
label="This is " & c:/data/macro.xla!macro (variabletouse)
so that the label reads "This is test123"

 

[RoryA]

I confess I do not know if it is possible to specify callbacks in the officeUI file, but I doubt it. You would need to alter the CustomUI part of the add-in and have it create the button when loaded. You can then use callbacks like getLabel to alter the label of the control as need be.