| Home |
| Search |
| Today's Posts |
|
#8
|
|||
|
|||
Can you explain in more detail please?
"crispbd" wrote: If you just want to navigate to a selected sheet based on the 2 list items, try this: Given: Cell A1 has the semester, Cell B1 has the Course 1) Goto View:ToolBars:Control Toolbox 2) From the Toolbox, click the button icon, 3) draw a button on this sheet 4) double click it to go to the VB code, 5) paste this into the button's code: On Error Resume Next Sheets(Cells(1,1).value & " " & Cells(1,2).value).Activate This will activate the sheet which is the combination of the semester (plus a space) and course: "Fall 04 History" for example, if Fall 04 is in one list, and History is in the second list. -- crispbd ------------------------------------------------------------------------ crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880 View this thread: http://www.excelforum.com/showthread...hreadid=319799 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation Window? | Excel Discussion (Misc queries) | |||
| Data Validation List =Name | Excel Discussion (Misc queries) | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
| Data Validation Formula Help | Excel Worksheet Functions | |||
| data validation on sth else | Excel Worksheet Functions | |||
Threaded Mode
