Calender function

  • Thread starter Thread starter John Welcher
  • Start date Start date
J

John Welcher

I want to be able to insert a drop down function in a cell
in Excel that when I click on the drop down arrow, I get a
monthly calender to pick dates from instead of typing them
in. This feature exists in MS Project.
 
Ron
Here's what I have done so far. I inserted the calender
control onto my worksheet and can see a full month's
calender. I then right-clicked on the worksheet tab at
the bottom where this worksheet's name appears and then
clicked on View Code. I copied your code from the link
you sent me and pasted it into here and then clicked alt-Q
to go back to my excel sheet.

any suggestions - thanks for all of your help
John
-----Original Message-----
Hi John

Have you copy it in a Sheet module ?, not a normal module


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)




"John Welcher" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Hi John

The example on my site will only work in this range

Range("A1:A100")

If you select a cell outside that range it will disappear and if you select a cell in the range it will popup
 
Back
Top