Thanks for that Chip but to be more specific

You mention drag and drop the control onto the userform. which control
do you use do you use the frame, combobox or is dtpicker in its own
right a control that you use and if so how do you add this control to
the standard list of controls.

Regards,
TDR


Chip Pearson Wrote:
> You simply drag and drop the control on to the userform, and
> resize it to the desired size. You get the currently selected
> date with the Value property. E.g.,
>
> MsgBox Me.DTPicker1.Value
>
> You might want to be more specific in your question. What
> problems are you having with the control?
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
>
> "TDR" TDR.1tg3yr@news.excelbanter.com wrote in message
> news:TDR.1tg3yr@news.excelbanter.com...-
>
> Hi,
>
> Can you please show me how to use dtpicker in a userform. I am
> new to
> vba and i am having some trouble trying to understnad this
> part.
>
> Thanks
>
>
> --
> TDR-


--
TDR