Microsoft Date and Time Picker control for User Form

[Luke]

I found this handy little control recently and was wondering whether it is
possible to refer to a cell in a worksheet in the MaxDate field. This is for
a workbook I update every month and I don't want anyone to be able to select
a date that is past the end of the month. I know I can write a small test
for it, but I'd rather just use the MaxDate field. Can it be done that way?

 

[Patrick Molloy]

you can't set the property directly to a range, so do it when the form
initialises:

Private Sub UserForm_Initialize()
DTPicker1.MaxDate = Range("B2")
End Sub

where B2 is a date. Tested fine

 

[Luke]

Ahhh, that will work nicely. The more I learn about this stuff, the more I
realize there is so much I don't know.

Thanks for the quick response.