Char data type to datetime data type

[clayton74]

I have a textbox that I would like the data type to be a datetime type instead of a char data type. Any help would be appreciated

 

[RobBroekhuis]

A textbox contains, per definition, text. You can regulate what kind of text is entered using validations in various events (textbox1_change, textbox1_exit). Alternatively, you can use some custom controls: Calendar control, DateTimePicker control, which have the validations already built in.
Rob

 

[clayton74]

Sorry to ask newbie questions. I can not find any infomation about DateTimePicker control is it a file that requires downloading

 

[RobBroekhuis]

DTPicker is in the collection of Microsoft Windows Common Controls. Establish a reference to this library using (from VBE) tools - references, and checking the name of the library. Then, while editing your userform, right-click on the controls toolbox, choose "additional controls", and select "Microsoft Date and Time Picker". This will put an icon for this control in your toolbox, after which you can drag one onto your userform. The use is fairly straightforward - take a look at the available properties and give it a try!
Rob

 

[clayton74]

Thanks for your time Rob, much appreciated