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?
Martin LissConnect With a Mentor Older 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

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.
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.