Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here's my question:
I have a userform with a few textboxes on it, and I want the textboxes to display only values of the form dd/mm/yyyy ALL THE TIME. The checking of the day-, month- and year-values shouldn't happen until I leave the textbox. But I want to use the keypress-event of the boxes to guarantee the right format all the time. I've already managed to do this for typing new values, so I only accept numbers from now on. This all works fine, but if I want to erase my date, I want to manipulate my textbox so I can erase the numbers, but NOT the slashes, so that I can't empty the box completely. It should contain always at least: "//". Does anyone know the answer to my problem? Thx, Lieven __________________________________________________ _____________________ Lieven Mettepenningen Software Designer NISUS Software Architects Antwerpsesteenweg 107, B-2390 Oostmalle Tel : +32(0)3/312.92.30 Fax : +32(0)3/311.72.90 http://www.nisus.be |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
TextBox format? | Excel Discussion (Misc queries) | |||
how to format text in textbox? | Excel Discussion (Misc queries) | |||
TextBox format? | Excel Discussion (Misc queries) | |||
Date format textbox | Excel Discussion (Misc queries) | |||
TextBox Format | Excel Discussion (Misc queries) |