| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro that Finds the First Value in a range using a Combobox (drop down menu)
I have a long list of countires and some info attached to them in a
spread sheet. I want to add a drop-down menu at the top of the spread sheet that will go to the first cell in the column that contains that text. E.G. If I choose Peru from the menu I want it to go to that exact cell in the spread sheet so scrolling isn't necessary. Does anyone know any VBA code that I can assign to this control?- It's Forms not ActiveX. Thanks. Matt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a macro that finds values then sorts | Excel Worksheet Functions | |||
| Developing macro event to allow multiple choices on drop down menu | Excel Worksheet Functions | |||
| Need a formula that finds the last used cell in a range | Excel Worksheet Functions | |||
| macro that finds text and keeps only part of it | Excel Discussion (Misc queries) | |||
| Excel finds a value that is not in the lookup range | Excel Worksheet Functions | |||
Threaded Mode
