CODEWITHSUNDEEP
vbacomboboxexcel-2007ribbon
Deepak
Deepak

Reputation: 1258

Excel 2007 Ribbon combobox events

In office 2007 i created a combo box on the ribbon based on the material here Source Page The combo box works fine except, when i choose the same item in succession , in this case the onChange event does not fire. Is there some way to fix this. It seems onAction event does not work for ComboBox.

I really would appreciate any help...

Upvotes: 0

Views: 1983

Answers (2)

Carlos AR
Carlos AR

Reputation: 1

Use a oRibbonCMM.InvalidateControl ("yourcontrolID") just after you select the item, I haven't tested this but I think it should work

Upvotes: 0

Deepak
Deepak

Reputation: 1258

It seems both combobox only has a 'onChange' event, so will not fire unless we change the selection. Maybe a dropdow list may work as it has a 'onAction' event. As a work around i placed a dummy at the top of the list which can be used to change selection. I know this is a stupid work around but it will have to do untill i check out the other options like a Dropdown list.

Upvotes: 1

Related Questions