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.
Frank FreeseAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
Can you attach your workbook?
Frank FreeseAuthor Commented:
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.
Frank FreeseAuthor Commented:
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.
Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

Martin LissOlder than dirtCommented:
Turn on DesignMode, right click on the combobox, select Properties and enter B6:B38 in the 'ListFillRange' property. Then add this code in the code for the Menu sheet.

Private Sub LogicalFunctions_Click()
Application.Goto Range("B" & LogicalFunctions.ListIndex + 5)
End Sub

Open in new window


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Frank FreeseAuthor Commented:
that is exactly what I was looking for. thank you so very much
Martin LissOlder than dirtCommented:
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
Frank FreeseAuthor Commented:
I thought of that but there is a little bit more information on the formula or function that what the name implies. Appreciate it.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.