Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calendar control
I used Ron's calendar control and it is slick! I can see in the click-event
that the date is custom formatted to mm/dd/yyyy. I want to add the day of the week in front of the date. Is it as simple as changing this line of the macro, and if so, what should it say? Thanks so much, Pam |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
calendar control
Hi Pam
Use this then ActiveCell.NumberFormat = "dddd mm/dd/yyyy" -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Pam M" wrote in message ... I used Ron's calendar control and it is slick! I can see in the click-event that the date is custom formatted to mm/dd/yyyy. I want to add the day of the week in front of the date. Is it as simple as changing this line of the macro, and if so, what should it say? Thanks so much, Pam |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
calendar control
oh so close...I tried with ddd and gave up to soon. This works
perfectly--thank you so much! "Ron de Bruin" wrote: Hi Pam Use this then ActiveCell.NumberFormat = "dddd mm/dd/yyyy" -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Pam M" wrote in message ... I used Ron's calendar control and it is slick! I can see in the click-event that the date is custom formatted to mm/dd/yyyy. I want to add the day of the week in front of the date. Is it as simple as changing this line of the macro, and if so, what should it say? Thanks so much, Pam |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
calendar control
ddd will give you the short name
Like Sat -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Pam M" wrote in message ... oh so close...I tried with ddd and gave up to soon. This works perfectly--thank you so much! "Ron de Bruin" wrote: Hi Pam Use this then ActiveCell.NumberFormat = "dddd mm/dd/yyyy" -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Pam M" wrote in message ... I used Ron's calendar control and it is slick! I can see in the click-event that the date is custom formatted to mm/dd/yyyy. I want to add the day of the week in front of the date. Is it as simple as changing this line of the macro, and if so, what should it say? Thanks so much, Pam |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
calendar control
I must have done something wrong the first time. I tried it again with ddd,
and it works also. Thanks for your help. "Ron de Bruin" wrote: ddd will give you the short name Like Sat -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Pam M" wrote in message ... oh so close...I tried with ddd and gave up to soon. This works perfectly--thank you so much! "Ron de Bruin" wrote: Hi Pam Use this then ActiveCell.NumberFormat = "dddd mm/dd/yyyy" -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Pam M" wrote in message ... I used Ron's calendar control and it is slick! I can see in the click-event that the date is custom formatted to mm/dd/yyyy. I want to add the day of the week in front of the date. Is it as simple as changing this line of the macro, and if so, what should it say? Thanks so much, Pam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calendar Control Help | Excel Programming | |||
Calendar Control | Excel Programming | |||
Control disappeared problem - specifically, the Calendar Control | Excel Programming | |||
Calendar Control | Excel Programming | |||
Calendar Control: Can't exit design mode because control can't be created | Excel Programming |