I have a custom Ribbon with an button label that I would like to update, on the fly, anytime a particular VBA Event fires.
Basically I need the Button Label to update to the value calulated during the event.
Just a way of seeing this value change in real time, in the Ribbon.
So, In a nutshell.
In Excel 2016 we have a Custom Group with custom button on the ribbon.
We are using the button label as the Text feild to update. (Opten to options on that.)
Using VBA we catch a value from a worksheet cell and update a button label with that value.
If anyone has already done this, or is confident they can please let me know.