set date format of text box
 

I have a user form text box that I want to format so on a
date (01/01/04) can be inputed. How can I set the format
to only accept a date format?

My spreadsheet date column is formatted for the date but
my user form accepts any input and populates the
spreadsheet!

set date format of text box
 

Dan,

This will check if it's a date:

If IsDate(Me.Textbox1.Text) then
' yada yada
End if

Or you could use the Calendar Control from Additional Controls in the
UserForm Toolbox.

hth,

Doug Glancy

"Dan" wrote in message
...
I have a user form text box that I want to format so on a
date (01/01/04) can be inputed. How can I set the format
to only accept a date format?

My spreadsheet date column is formatted for the date but
my user form accepts any input and populates the
spreadsheet!