LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Format textbox for dates

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TextBox format? Pas Excel Discussion (Misc queries) 5 April 25th 10 11:13 PM
how to format text in textbox? ghost Excel Discussion (Misc queries) 1 May 18th 08 10:41 AM
TextBox format? AOU Excel Discussion (Misc queries) 4 June 12th 07 11:24 PM
Date format textbox George Excel Discussion (Misc queries) 2 September 20th 06 09:09 PM
TextBox Format grahammal Excel Discussion (Misc queries) 3 March 29th 06 01:35 PM


All times are GMT +1. The time now is 09:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"