Pop up calendar

[ribhead]

I have a calendar on a userform and I'm wondering what is the code to change the calendar back to the current date? Probably something really dumb.

I may not be very smart but I'm sure wirey!!!!

 

[Zathras]

Something like this, maybe?
[blue]

Private Sub CommandButton1_Click()
  Calendar1.Day = Day(Now)
  Calendar1.Month = Month(Now)
  Calendar1.Year = Year(Now)
End Sub

[/color]

 

[ribhead]

nevermind I had useform_click and not activate.

Actually this is all it is.


calendar1.value = Now

I may not be very smart but I'm sure wirey!!!!

 

[PeterMoran]

Hi ribhead,

The third FAQ under the Microsoft Office forum provides a url to Martin Geen's VBA site which gives full details about creating a popup calendar - Just in case you have any further problems getting your popup calendar to work.

Good Luck!

Peter Moran
Two heads are always better than one!