| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro that Finds the First Value in a range using a Combobox (drop
If you have a LINK cell e.g. B1, then this will scroll to the cell in Column A.
This assumes data (your country list) starts in row 1. Sub DropDown2_Change() ActiveWindow.ScrollRow = Range("B1") End Sub HTH " wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro that Finds the First Value in a range using a Combobox (drop
On Jul 12, 4:52 am, Toppers wrote:
If you have a LINK cell e.g. B1, then this will scroll to the cell in Column A. This assumes data (your country list) starts in row 1. Sub DropDown2_Change() ActiveWindow.ScrollRow = Range("B1") End Sub HTH " wrote: 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- Hide quoted text - - Show quoted text - I failed to mention that the countries are not in consecutive order. There are a few rows between each country. Is there a formula that will match the text chosen from the drop down menu to the text in the spread sheet? |
| Reply |
| 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 | |||
Linear Mode
