I'm really strugling with this one...
I'm trying to create a spreadsheet that has a custom control in the ribbon. This contol will be an EditBox. I would like the label for this control to be dynamic. The label will be fed from a cell on my Excel spreadsheet.
How do I "trigger" the label to update? I would like to put code in my Worksheet_Change event that will update the label. How do I call a Ribbon event from VBA?
I hope this make sense.
You can't from VBA. You can use callback code to set the label, but that callback is invoked when the ribbon starts up. You cannot change it from some Excel event I am afraid.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
If I understand what you want to do, I usually .Invalidate the control from VBA
That will cause the Ribbon control to 're-initialize' itself and pick up any status, etc. changes
Paul
The Invalidate did the trick. Thank you very much.
Posting Permissions
Reply With Quote
