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.
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.
Martin Liss
Can you attach your workbook?
ASKER
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
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
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
In any case you're welcome and I'm glad I was able to help.
Marty - MVP 2009 to 2013
ASKER
I thought of that but there is a little bit more information on the formula or function that what the name implies. Appreciate it.