Writing data to a calendar control

[redpower_1]

On a userform, can you put data in a calendar control, similar to a planner? For example, there is a meeting on Friday. How could I write "Meeting 7:00 pm" to the Friday box on the calendar control?

-Kris

 

[Tinbendr]

The calendar control is nothing more than a calendar that, when double-clicked, returns the selected date in a variable. Then you have to do something with that variable.

What did you want to do with that date?

 

[redpower_1]

Thanks for the reply. I've been using the DTPicker drop down box to select dates on my userforms, and then entering text and other data events for that specific date. Sometimes it's easier to visually see the events on a calendar rather than a list of dates. I'm sure there are programs out there that do that(Outlook?). It's really not a problem, just an idea I had to make my forms more user friendly.
Kris

 

[Tinbendr]

Just drop the calendar control on the userform. On the code page use something like this.

Private Sub Calendar1_DblClick()
ActiveCell = Calendar1.Value
End Sub