dialog box validation

's Computer Specifications

I am a problem with dialog boxes in excel 2000

1. I need a code so when the person clicks ok it checks the comment
box to make sure there is a 5 character string in the box (could be
both numbers and letters)

's Computer Specifications

Try creating a simply form.
Place a textbox on it, and set the MAXLENGTH value to 5.
Place a commandbutton on the form to process the value entered.

Corey....

<(E-Mail Removed)> wrote in message
news:173c1175-9d11-49e4-afb2-(E-Mail Removed)...
>I am a problem with dialog boxes in excel 2000
>
> 1. I need a code so when the person clicks ok it checks the comment
> box to make sure there is a 5 character string in the box (could be
> both numbers and letters)

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data Validation dialog box NO in-cell dropdown option	Paul B	Microsoft Excel Misc	3	19th Oct 2006 12:16 AM
Input text message (dialog box) for data validation	chuckandden@yahoo.ca	Microsoft Excel Discussion	2	27th Sep 2006 04:02 PM
Modeless Dialog calls Modal Dialog. Hide causes application to lose focus.	Tom Clement	Microsoft Dot NET Framework Forms	3	27th Jun 2005 09:44 AM
How-to exit button click event of ( C#) modal dialog without exiting dialog?	Lew Barnesson	Microsoft Dot NET Framework Forms	3	2nd Jun 2005 11:03 PM
.Net Validation within Modal Dialog Box possible???	Earl Teigrob	Microsoft ASP .NET	3	16th Apr 2004 07:11 PM