Excel 97, text box Input Mask, local date format
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 |
Excel 97, text box Input Mask, local date format
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 . |
Excel 97, text box Input Mask, local date format
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 . |
Excel 97, text box Input Mask, local date format
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 . |
All times are GMT +1. The time now is 09:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com