Is it possible to have a Pop-up Calendar appear when I click on a cell from
wince I may choose any day or month with my mouse. Much like you would see
if you were using Microsoft Money and you clicked on the drop down arrow of
the Date Box.

Thank-you

Hi KLB

See this page
http://www.rondebruin.nl/calendar.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"KLB" wrote in message ...
Is it possible to have a Pop-up Calendar appear when I click on a cell from
wince I may choose any day or month with my mouse. Much like you would see
if you were using Microsoft Money and you clicked on the drop down arrow of
the Date Box.

Thank-you

Wow, thank you. This is just what I wanted.

In the code the format for the cell is

ActiveCell.NumberFormat = "mm/dd/yyyy"

Where the result is 09/29/2007

Is it possible to change this code so that the result is

September 29, 2007

or

Sept, 29th

I can right click my cell after I have chosen the date, right click and
format the cell to a date format I prefer but if I choose to change the date
I loose the format and it returns to the default format of the Calendar
code.

Actually I have answered my own question.

I changed the mm/dd/yyyy to mmm / dd and got the results I was looking for.

Thank you Ron