View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default exact number of characters in textbox

in the appropriate event for the textbox, use the len function

if len(me.Textbox1.Text) < 11 then

There are two kinds of text boxes and textboxes can be located on
worksheets, userforms, dialogsheets, and a more specific answer would
require more specific knowledge although you will probably get some guesses.

--
Regards,
Tom Ogilvy

"JNW" wrote in message
...
The program I am developing requires employees to enter information about
customer numbers. These customer numbers are always 11 digits long. I

know
how to limit the textbox to 11 characters but how do I check to see if all

11
characters were entered?