Monthview show/hide

[dkndnb]

Hi all,

Had a search for this but couldn't find anything.... hopefully someone can help!

Basically I'm designing a user form and want the date picker to 'pop up' / appear when the user clicks in the text box and disappear when they click out of it. The input to the calendar currently populates the text box.

I'm currently using this but it won't reappear after an exit. Plus if I have it set to hidden on Initialize, I can't get it to appear. Essentially.... it's not appearing :D


Private Sub TextBox1_Enter()
Me.MonthView1.Visible = True
End Sub


Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Me.MonthView1.Visible = False
End Sub

Any help much appreciated! Or if there's a better way to go about using the MonthView control, please do enlighten me!

 

[dkndnb]

Anyone? Sorry to bump so quickly but I'm working to a tight deadline...

 

[dkndnb]

Bump...