ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do you use DTpicker in a Userfrom (https://www.excelbanter.com/excel-discussion-misc-queries/39201-how-do-you-use-dtpicker-userfrom.html)

TDR

How do you use DTpicker in a Userfrom
 
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

Chip Pearson

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" wrote in message
...

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

Chip

Thanks for that problem solved

Regards,
TDR


Quote:

Originally Posted by Chip Pearson
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" wrote in message
...

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



All times are GMT +1. The time now is 03:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com