Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Calendar control to display dates
I visit the Ron De Bruin site for information on the Calendar control.
However, he only gives an example of how the calendar control can be used as a date picker. I would like to use the control to display predefined dates on another sheet in the same book. So it is really just a graphical viewer. Example is sheet1, Column A would have project names, Column B would have targeted installation dates. Sheet2 would be my calendar control to view the sheet1 data. Any ideas would be much obliged. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Calendar control to display dates
Hi
You can attach code to the calendar by right clicking it and choosing View Code. You could attach code to the calendar's Click event or the sheets Activate even, for example. Here are some examples of code: Calendar1.Day = Day(Now()) Calendar1.Month = Month(Range("A2") Calendar1.Year = Year([A2]) where A2 contains a legal date -- Cheers, Shane Devenshire Microsoft Excel MVP "Ronio" wrote: I visit the Ron De Bruin site for information on the Calendar control. However, he only gives an example of how the calendar control can be used as a date picker. I would like to use the control to display predefined dates on another sheet in the same book. So it is really just a graphical viewer. Example is sheet1, Column A would have project names, Column B would have targeted installation dates. Sheet2 would be my calendar control to view the sheet1 data. Any ideas would be much obliged. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Calendar control to display dates
That works if I only need to view one entry at a time. I was hoping for a
view that would show multiple entries at the same time. "ShaneDevenshire" wrote: Hi You can attach code to the calendar by right clicking it and choosing View Code. You could attach code to the calendar's Click event or the sheets Activate even, for example. Here are some examples of code: Calendar1.Day = Day(Now()) Calendar1.Month = Month(Range("A2") Calendar1.Year = Year([A2]) where A2 contains a legal date -- Cheers, Shane Devenshire Microsoft Excel MVP "Ronio" wrote: I visit the Ron De Bruin site for information on the Calendar control. However, he only gives an example of how the calendar control can be used as a date picker. I would like to use the control to display predefined dates on another sheet in the same book. So it is really just a graphical viewer. Example is sheet1, Column A would have project names, Column B would have targeted installation dates. Sheet2 would be my calendar control to view the sheet1 data. Any ideas would be much obliged. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Calendar control to display dates
Calendar controls do not have a multi select option...
-- HTH... Jim Thomlinson "Ronio" wrote: That works if I only need to view one entry at a time. I was hoping for a view that would show multiple entries at the same time. "ShaneDevenshire" wrote: Hi You can attach code to the calendar by right clicking it and choosing View Code. You could attach code to the calendar's Click event or the sheets Activate even, for example. Here are some examples of code: Calendar1.Day = Day(Now()) Calendar1.Month = Month(Range("A2") Calendar1.Year = Year([A2]) where A2 contains a legal date -- Cheers, Shane Devenshire Microsoft Excel MVP "Ronio" wrote: I visit the Ron De Bruin site for information on the Calendar control. However, he only gives an example of how the calendar control can be used as a date picker. I would like to use the control to display predefined dates on another sheet in the same book. So it is really just a graphical viewer. Example is sheet1, Column A would have project names, Column B would have targeted installation dates. Sheet2 would be my calendar control to view the sheet1 data. Any ideas would be much obliged. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calendar control | Excel Discussion (Misc queries) | |||
Hyperlink from dates in Calendar Control 11.0 | Excel Discussion (Misc queries) | |||
Calendar Control | Setting up and Configuration of Excel | |||
Calendar Control in Excel 2000 can't display date in Excel 2003? | Excel Discussion (Misc queries) | |||
Display dates from an Excel spreadsheet in a calendar? | Excel Worksheet Functions |