Posted to microsoft.public.excel.programming

Lou

external usenet poster

Posts: 5

Validateing a txtbox from form

I have a form that has textbox txtAN after the cmbbutton is clicked I want to verify that the information in the txtAN box is 5 numbers. It has to be 5 number no more/no less and no alpha charecters. How do you make this check occure

If txtAN < 5 Then GoTo errmsgbx Else I started with this but this is not correct. Any help would be great thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
VBA: Update worksheet when txtBox data changes.	Mcasteel	Excel Worksheet Functions	2	November 14th 04 11:59 PM
VBA: Update worksheet when txtBox data changes.	Mcasteel	Excel Worksheet Functions	1	November 13th 04 03:19 PM
VBA: Update worksheet when txtBox data changes.	Mcasteel	Excel Worksheet Functions	1	November 1st 04 06:18 PM
VBA question - Inputing data to txtbox in userform using short date formart	ajliaks[_2_]	Excel Programming	2	April 13th 04 11:45 AM
txtbox code	Sal_sal	Excel Programming	1	December 12th 03 11:25 AM

All times are GMT +1. The time now is 10:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us