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" wrote:

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?