Findout Data type

[tqm1]

Dear Sir,

In userform's Textbox2 value is 15-06-1950
Could I know the type of data in textbox2, i.e integer,string,date etc.

Please help

[VBA Noob]

Try isdate

http://msdn2.microsoft.com/en-us/lib...k9(VS.80).aspx

VBA Noob

[mikerickson]

A TextBox's value is always a string.

MsgBox TypeName(Userform1.TextBox1) & vbCrLf _
        & TypeName(Userform1.TextBox1.Value)

is a way to find out the type of a variable or object.