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!

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!