Using Macros on ComboBox within the Ribbon

**DougQval** · 10-09-2009, 12:22 PM

I use macros to navigate within spreadsheets based on predefined named locations. I was able to assign these "GoTo" macros to buttons on the Ribbon. I am trying to assign the same macros to a ComboBox, but I can't figure out how to do it. Here's the button macro that works fine.

<button id="rxbtnGoTo_Historicals"
label="Hist"
imageMso="AppointmentColor2"
onAction="rxbtnGoTo_Historicals_Click"/>

Here's my attempt at assigning the same macro to a ComboBox. However, when I try to validate it, I get this error message: "onChange attribute is not declared".

<comboBox id = "NavigationDropDown"
label = "Navigation"
onChange = "rxcboNavigationDropDown_Click">
<item id = "rxitemcboGoTo_Historicals"
label = "Hist"
onChange = "rxitemGoTo_Historicals"/>

Can you please tell me what I'm doing wrong or provide some guidance?

Thanks

**romperstomper** · 10-09-2009, 12:30 PM

I would have thought you just use the onChange of the combo itself (the items don't have one AFAIK) and then in the callback check the text argument (i.e. the selected item) to determine what you should run.

**DougQval** · 10-09-2009, 01:26 PM

What's "AFAIK"? Is having Items necessary?

BTW, Romperstomper is a good flick.

**DougQval** · 10-09-2009, 04:31 PM

I think I figured it out.

**romperstomper** · 10-09-2009, 06:50 PM

AFAIK = As Far As I Know!

**royUK** · 10-10-2009, 04:50 AM

Originally Posted by DougQval

I think I figured it out.

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save