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 VBA Question: User Form and input masks


Hi!

I've created a User Form for people who are not experienced with Excel
The form includes text boxes as well as pull-downs (combo boxes).
was wondering if there was a way to use input masks (like in Access) t
prevent uses from entering inappropriate data.

For example, I have several date fields. Is it possible to have m
user form already have a mm/dd/yyyy format for them? Or, if that's no
possible, is there some way to make the User Form beep at them? I hav
prompts in the labels next to the boxes, but I'm afraid it won't b
enough.

The people on this forum have been so helpful. Thank you very much.

Sincerely,
Marianne :

--
Marianne
-----------------------------------------------------------------------
MarianneR's Profile: http://www.excelforum.com/member.php...nfo&userid=625
View this thread: http://www.excelforum.com/showthread.php?threadid=47595

 
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
Input Masks or equivilent Courtney Excel Worksheet Functions 1 January 13th 07 02:57 AM
Are Input masks available in Excel? Ray with Group O Excel Discussion (Misc queries) 0 November 8th 06 03:34 PM
Input masks in Excel Chris Excel Discussion (Misc queries) 1 October 16th 06 09:47 PM
VBA Question: User Form and input masks MarianneR[_4_] Excel Programming 0 October 13th 05 07:41 PM
input masks and validation archiboy Excel Discussion (Misc queries) 3 October 11th 05 03:05 PM


All times are GMT +1. The time now is 06:18 AM.

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"