Find Date cell using Calendar Control

  • Thread starter Thread starter Mik
  • Start date Start date
M

Mik

I have a list of dates (in sequence) in cells A3:A100.
A calendar control inserted into my worksheet (not via a userform),
currently displays the chosen date in cell A1.

This works fine, however....

When the date is chosen from the calendar control, I want to select /
goto the corresponding date within cells A3:A100.

How can this be done?

For info, I'm using Calendar Control 11.0, and Excel 2007 and 2010.
 
Mik said:
I have a list of dates (in sequence) in cells A3:A100.
A calendar control inserted into my worksheet (not via a userform),
currently displays the chosen date in cell A1.

This works fine, however....

When the date is chosen from the calendar control, I want to select /
goto the corresponding date within cells A3:A100.

How can this be done?

For info, I'm using Calendar Control 11.0, and Excel 2007 and 2010.
Click to expand...

Something like this, perhaps?

For ro = 3 To 100
If CDate(Cells(ro, 1).Value) = Calendar1.Value Then
Cells(ro, 1).Select
Exit For
End If
Next
 
Back
Top