View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ste ste is offline
external usenet poster
 
Posts: 18
Default 2nd Post - Cannot select day on Calendar if ValueIsNull is True

Hi sivadd,

why dont you set the value by code?

Private Sub UserForm_Initialize()
Calendar1.Value = Now
End Sub

regards,
ste