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

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
.

Hi, it doesn't realy help because I need to have in the text box the input
mask dd.mm.yyyy and for that to remain when they start to type a date and
once they have type the date, the cursor jumps to the month so the user does
not have to enter the date sparator.

I'll keep looking, thank anyway.

Thanks In Advance (TIA)
KM

"GJones" wrote:

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
.

Not supported in any controls provided with Excel.

--
Regards,
Tom Ogilvy

"Kevin McCartney" wrote in
message ...
Hi, it doesn't realy help because I need to have in the text box the input
mask dd.mm.yyyy and for that to remain when they start to type a date and
once they have type the date, the cursor jumps to the month so the user
does
not have to enter the date sparator.

I'll keep looking, thank anyway.

Thanks In Advance (TIA)
KM

"GJones" wrote:

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
.