Is a Pop-up Calendar Possible?

K

KLB

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
 
K

KLB

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.
 
K

KLB

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
 
Top