Pop-Up Calendar default date 1

[vestax22]

Hi, I'm using Excel 2000. I have a userform which contains a Pop Up Calendar. I want to thefault value to be the date.
Does anybody know how to do this?

I tried changing the value to date(), now(), today() but nothing worked. Any help would be greatly appreciated. Thx

 

[Bowers74]

Did you enter an equals (=) sign before TODAY(), DATE(), NOW()?

That might do the trick.

Did you create the pop-up calendar yourself or is it an OCX?

If you can't be "The Best", be the best at what you can!!!

Never say Never!!!
Nothing is impossible!!!

 

[vestax22]

Hey its an OCX

 

[Bowers74]

I'm going to assume that you are using an OCX and that it is located on a UserForm.

In the Initialize Event of the form enter:

Calendar1.Value = Format(Now(),"Short Date&quot

That should do the trick.

If you can't be "The Best", be the best at what you can!!!

Never say Never!!!
Nothing is impossible!!!