Excel 97, text box Input Mask, local date format

G

Guest

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
 
G

GJones

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Input Mask Question 4
Date input format 2
long date format for report input mask 1
Properties - Format, Input Mask, Validation Rule 5
Format an Excel Column in the window's short date format. 7
Date format -medium date input mask-French Canadian 5
Input Masking a Text box 1
Input Mask for Date and Time 2

Top