Solved: RibbonX - Label update

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.

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.