Avatar of Frank Freese
Frank FreeseFlag for United States of America asked on

Use of combo box in Excel 2007

Folks,
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.
Microsoft Excel

Avatar of undefined
Last Comment
Frank Freese

8/22/2022 - Mon
Martin Liss

Can you attach your workbook?
ASKER
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.
Function-and-Formulas-for-Excel-.xlsm
ASKER
Frank Freese

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.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER CERTIFIED SOLUTION
Martin Liss

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Frank Freese

that is exactly what I was looking for. thank you so very much
Martin Liss

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
ASKER
Frank Freese

I thought of that but there is a little bit more information on the formula or function that what the name implies. Appreciate it.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.