Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I'd like to create a list box containing "jumps" to other cells...
....I have a simple calendar spreadsheet in Excel 2002 (12 months on one
sheet, arranged vertically). I'd like to add a list box in A1 that contains months - when you choose one, the cursor jumps to the beginning of that month? I'm sure this is possible - the best way please? Thanks in advance Amanda |
#2
|
|||
|
|||
Maybe you could set up a list of month names on another sheet.
Then use Data|validation in A1--and use that list as the source. See Debra Dalgleish's site to see how to point to a range on another sheet: http://www.contextures.com/xlDataVal01.html#Create Then create names for 12 cells on that calendar sheet. (January, February, ..., December) Deb's site, again: http://www.contextures.com/xlNames01.html#NameBox Then rightclick on the worksheet tab that has the calendar and select view code. Paste this in: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub If Intersect(Target, Me.Range("a1")) Is Nothing Then Exit Sub On Error Resume Next Application.Goto Target.Value, scroll:=True If Err.Number < 0 Then MsgBox "Design error!!!" Err.Clear End If On Error GoTo 0 End Sub (If you use this with xl97, it won't work--it was a bug that was fixed in xl2k.) Birmangirl wrote: ...I have a simple calendar spreadsheet in Excel 2002 (12 months on one sheet, arranged vertically). I'd like to add a list box in A1 that contains months - when you choose one, the cursor jumps to the beginning of that month? I'm sure this is possible - the best way please? Thanks in advance Amanda -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a cascading list box using Excel | Excel Discussion (Misc queries) | |||
Is there a way to create a drop-down list of links in Excel? | Excel Worksheet Functions | |||
The pivot tables 101 article says to use the "Create List" comman. | New Users to Excel | |||
create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
How do you create a drop down list? | Excel Discussion (Misc queries) |