shockandawe
08-19-2011, 08:57 AM
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.
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.