Hi TIA;

You would probably need to let them give you the date the
way they want and then convert it. I went to VBA help in
Excel and found the following listings:


User-Defined Date/Time Formats (Format Function)

User-Defined Date/Time Formats Example

I hope that helps,

Greg


-----Original Message-----
Hi TWIMC,

How do I put an input mask on a text box via VB code in
Excel 97 when the
form opens. The input mask I require relates to the date
input mask
"dd.mm.yyyy" or what ever the regional settings of the
computer being sued
are set to for a short date format.

TIA
KM
.