Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down List Selection... Then go to The Cell / Range
What code would I need to be able to Select a Month from a drop down list,
then jump to the area of my worksheet that the month is situated. Its like a GOTO command except I'm selecting from a drop down list. I can create dropdown lists and can create a macro to goto a specific cell, but how do I incorporate this within a drop down list? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down List Selection... Then go to The Cell / Range
I assume you mean the list option in Data = Validation
If you are using Excel 2000 or later, then making the selection should trigger the Change event. Use the Target argument of the Change event to see if it was your dropdown cell which triggered the event. If so, check the value and then execute code that positions the selection in accordance with the value of Target. See Chip Pearson's page on Events for general information on events http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "John" wrote in message ... What code would I need to be able to Select a Month from a drop down list, then jump to the area of my worksheet that the month is situated. Its like a GOTO command except I'm selecting from a drop down list. I can create dropdown lists and can create a macro to goto a specific cell, but how do I incorporate this within a drop down list? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down List Selection... Then go to The Cell / Range
To go to a range on the worksheet, without programming, you can use
named ranges. For example, select cell A35 Click in the Name Box, to the left of the Formula Bar Type: February Press the Enter key to complete the naming Press Ctrl+Home to return to the top of the worksheet Click the dropdown arrow at the right of the Name Box Select February, and that will become the active range John wrote: What code would I need to be able to Select a Month from a drop down list, then jump to the area of my worksheet that the month is situated. Its like a GOTO command except I'm selecting from a drop down list. I can create dropdown lists and can create a macro to goto a specific cell, but how do I incorporate this within a drop down list? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down List Selection... Then go to The Cell / Range
Don't want to do that Debra because I have a whole series of ranges named
and it might confuse the user. By the way you have a very good web site "Debra Dalgleish" wrote in message ... To go to a range on the worksheet, without programming, you can use named ranges. For example, select cell A35 Click in the Name Box, to the left of the Formula Bar Type: February Press the Enter key to complete the naming Press Ctrl+Home to return to the top of the worksheet Click the dropdown arrow at the right of the Name Box Select February, and that will become the active range John wrote: What code would I need to be able to Select a Month from a drop down list, then jump to the area of my worksheet that the month is situated. Its like a GOTO command except I'm selecting from a drop down list. I can create dropdown lists and can create a macro to goto a specific cell, but how do I incorporate this within a drop down list? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selection of drop down list directs auto population of other cell | Excel Discussion (Misc queries) | |||
Return the cell reference of the drop down list selection. | Excel Worksheet Functions | |||
drop down list that changes cell color upon selection | Excel Discussion (Misc queries) | |||
Linking a selection in a drop down list to a calc in another cell | Excel Worksheet Functions | |||
Selection of Drop down list that allows you to go to a particular cell | Excel Worksheet Functions |