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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 03:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com