 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / May 2008calendar 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 Hi Pam Use this then ActiveCell.NumberFormat = "dddd mm/dd/yyyy"  SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm >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 oh so close...I tried with ddd and gave up to soon. This works perfectly--thank you so much! > Hi Pam > [quoted text clipped - 6 lines] > > 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 ddd will give you the short name Like Sat SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm > oh so close...I tried with ddd and gave up to soon. This works > perfectly--thank you so much! [quoted text clipped - 9 lines] >> > 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 I must have done something wrong the first time. I tried it again with ddd, and it works also. Thanks for your help. > ddd will give you the short name > [quoted text clipped - 13 lines] > >> > 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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.