Set Calendar Control to Current Date (VBA Word 97)

Topic

New Reply

My user form has a Calendar control called “CalendarControl”. I want the current date to get focus when the form is loaded. I know this sounds like a simple thing but I can’t for the life of me get it to work. I thought I should just use:

CalendarControl.Value = Date

The value under properties keeps reverting back to the date I wrote the code…any help for this novice would be appreciated since it seems EVERYTHING I find on the internet has to do with Access, not Word and although similar, what works for Access doesn’t necessarily work for Word.

Reply | Quote

Replies

Try dropping the Value property and just set the calendar control equal to Date. Since the control isn’t an Access control at all, this should work in Word as well.

Reply | Quote

Thanks Charlotte — but that doesn’t work for me either…

Reply | Quote

Joanne,

Try “Now” rather than “Date”(?)

Gary

Reply | Quote

No luck… but thank you.

Reply | Quote

Where are you putting that code? It should be in the form initilize event routine.

Reply | Quote

Thanks to all who have made suggestions. I figured out the error of my ways…. and am absolutely mortified to admit that I had neglected to include the form name prior to the control…

Hence:

frmCalendar.CalendarControl = Date

Must have been a rougher weekend than I thought.

Reply | Quote

Using Option Explicit will find those kind of problems quickly.

Reply | Quote

Thank you Legare. I shall use that statement unfailingly in the future

Reply | Quote