Link to home
Start Free TrialLog in
Avatar of Frank Freese
Frank FreeseFlag for United States of America

asked on

Use of combo box in Excel 2007

I would like to incorporate combo boxes in a worksheet. The reason for this is that I would like the user to select a specific location on a worksheet from various cells using a combo box. Onced selected then they would go directly to that cell in Main Menu worksheet.
For example, if I have multiple cells that relate to Finance functions on the Main Menu I would select the combo box Finance and it would take me to that location on the Main Menu worksheet. From there the user then selects a command button that takes them to the worksheet that is an an example of the function the want to know more about.
I have 18 different categories, not just finance so there would be 18 different combo boxes.
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Can you attach your workbook?
Avatar of Frank Freese


You bet!
The attached workbook has a Main Menu tab. Concentrate on the Finance section only. It is color coded and there is a blank combo box located at A3. Ideally I would like to be able to populate that combo box in this example with what I have in cells B6 - B38. Once selected then the cursor would go to that location and the user from there can goto the worksheet they want more information on.
I've figurered out how to populate the combo box but cannot figure out how to code the combo box to go to the specific location selected.
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
that is exactly what I was looking for. thank you so very much
If you'd be interested in being able to programmatically click the GoTo button associated with the combobox entry instead of going to the 'Name of Function or Formula' cell associated with the combobox entry then let me know.

In any case you're welcome and I'm glad I was able to help.

Marty - MVP 2009 to 2013
I thought of that but there is a little bit more information on the formula or function that what the name implies. Appreciate it.