Search code examples
vbacomboboxexcel-2007ribbon

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...


Solution

  • 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.