restrict second digit entered into text box to "8"

**nigelog** · 08-22-2018, 07:02 AM

In a userform text box I have restricted the entries to only digits but I also need to check that the second digit entered is "8"
I have tried this in the text box change event

Please Login or Register  to view this content.

but it also reacts to the first entered entered digit because in that instance the second digit is blank

Is there a way around this
Help appreciated

**AB33** · 08-22-2018, 07:10 AM

May be

If len(TextBox1.Value) = 8 Then

end if

**kasan** · 08-22-2018, 07:17 AM

Try to add additional criteria on how long number is entered:

Please Login or Register  to view this content.

**nigelog** · 08-22-2018, 07:24 AM

@ kasan

Perfect
I had just tried

Please Login or Register  to view this content.

but wasnt right

many thanks

restrict second digit entered into text box to "8"

LinkBack

Thread Tools

Rate This Thread

Display

restrict second digit entered into text box to "8"

Re: restrict second digit entered into text box to "8"

Re: restrict second digit entered into text box to "8"

Re: restrict second digit entered into text box to "8"

Thread Information

Users Browsing this Thread

Similar Threads

"Error" or "Disallow" Entries If Data Entered in Wrong Cell

"Text string you entered is too long" error when plot point clicked

create text string: "NOT "[b2value]", NOT "[b3value]", ..., NOT "[b600value]"

[SOLVED] Combo list selected by "contains" text string entered rather than "begins with"

[SOLVED] Formula Needed to fill multiple cells with "No" when the word "No" is entered into a cell

[SOLVED] quick way to remove the "+" from engineering stations entered as text?

How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro

Bookmarks

Bookmarks

Posting Permissions