ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   calendar control (https://www.excelbanter.com/excel-programming/411594-calendar-control.html)

Pam M

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

Ron de Bruin

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


Pam M

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



Ron de Bruin

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



Pam M

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