Automattically go to section of a workfile

[mcwilson]

I have a calendar for each of the 12 months starting at cell AA (calendars go down from there)

If i enter in a date in cells B8 or B9, B11 or B12, B14 or B15, etc. etc. i want to go that specific month which is mentioned merely by clicking on the cell next to the date (C8 or C9, C11 or C12, C14 or C15, etc.)

any ideas? would a hyperlink work if i name the months? any vba code ideas?

Thanks!

 

[jasonb75]

Assuming months in the calendar are entered as "January" etc,

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
If Target.Column = 3 Then
Cells.Find(What:=Format(Target.Offset(, -1).Value, "mmmm"), After:=[AA1], LookIn:=xlValues, LookAt:= _
        xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:=False _
        , SearchFormat:=False).Activate
End If
End Sub

Works on double click.

 

[mcwilson]

You, kind sir, are a genius.
I cannot thank you enough.
God Bless