Dear All,

I have a user form that has several text boxs that require input. How do I
format these boxes / control what the user inputs into them.

ie on the change sub of the text box I need a control that says

If textbox1.numberformat = "dd-mm-yyyy" Then Next
Else
MsgBox("Please enter date as dd-mm-yyyy")


Furthermore I would also like to format a text box so that percentages can
be entered. At present I have had to highlight to the user that they need to
be entered as a decimal. Is there any way around this?


Thanks in advance

And thanks for all your previous help. Starting to get the basics of this
and put together some 'good' templates.

Kind Regards
Matthew Balch