Calendar popup

[Glen Mettler]

I am creating a user form that will allow the user to enter a deadline for
various tasks.
Is it possible to put a calendar control for the user to select from?

Glen

 

[JackD]

Yes. I just posted this an hour ago

You can use the Time and Date Picker control on a user form.
Insert a user form. Open the Control Toolbox (should be open anyway, but if
it is not then open it)
Go to tools menu, choose "Additional Controls"
Find "Microsoft Date and Time Picker Control X.0" and check it. Then drag it
to your form.
Set the events for it so that it returns a value when it changes:

Private Sub DTPicker1_Change()
MsgBox DTPicker1.Value
End Sub

Now your macro only needs to show the user form.

 

[Glen Mettler]

Jack,
Just exactly what I needed. Thanks!

Glen

Yes. I just posted this an hour ago

You can use the Time and Date Picker control on a user form.
Insert a user form. Open the Control Toolbox (should be open anyway, but
if
it is not then open it)
Go to tools menu, choose "Additional Controls"
Find "Microsoft Date and Time Picker Control X.0" and check it. Then drag
it
to your form.
Set the events for it so that it returns a value when it changes:

Private Sub DTPicker1_Change()
MsgBox DTPicker1.Value
End Sub

Now your macro only needs to show the user form.


--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

.