allow entry in only one txtbox

Guest

Posts: n/a

13th Dec 2006

I have a userform with 5 frames. Each frame has 2 txtboxes and 2 labels.
The user needs to enter a numeric value in one of the txtboxes but not both.

How to code the form to loop through the frames and check that only one in
each frame has an entry and then give a msgbox when the save button is
pushed?

Thank You
CR

« Install or protect an Excel spreadsheet? | Re: Macro to run when sheet activated »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
txtBox help	=?Utf-8?B?RGF2ZQ==?=	Microsoft Dot NET Framework Forms	3	7th Nov 2004 01:45 PM
txtbox	Delf	Microsoft Access	1	22nd Aug 2004 10:21 PM
TxtBox Properties	S Jackson	Microsoft Access Reports	1	29th Jul 2004 09:42 PM
txtbox?	Terry	Microsoft Access Form Coding	3	7th Jun 2004 02:17 AM
txtbox not getting a key	Cosh	Microsoft C# .NET	1	3rd Aug 2003 06:52 AM