Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Mik wrote:
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. 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 -- - Are you good with people? - I can kill one in less than two seconds! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Populating a Date-formatted Cell with ActiveX Calendar Control | Excel Programming | |||
Populate Cell Date Value with Active X Calendar Control | Excel Worksheet Functions | |||
How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
calendar/date control | Excel Programming |