Restrict entries in textboxes on userform

Hello everyone
I have a userform with textboxes ( 1 to 13 ) which should be restriected in entries as follows

First, Just the letter "A" is allowed in entry and no other letters or words or any text allowed ..just the letter "A" (Capital case)
-----
Second, each text box should be restricted by minimum and maximum value , as for the minimum for all the textboxes would be 0 but as for the maximum value related to cells in yellow (In Sheets("Data"))
For example : range("R12") has the value 50 >> So the textbox1 should be from 0 to 50 only and if it is less than 0 or greater than 50 , a message box would be appear to pay the user's attention ...

AC12 is related to Textbox2
AN12 is related to Textbox3
AZ12 is related to Textbox4
BA12 is related to Textbox5
BN12 is related to Textbox6
BO12 is related to Textbox7
CA12 is related to Textbox8
CL12 is related to Textbox9
CM12 is related to Textbox10
DO12 is related to Textbox11
DZ12 is related to Textbox12
EK12 is related to Textbox13

If possible I need to deal with all the textboxes all together that have the same conditions (I mean textboxes 1 & 2 & 3 & 7 & 8 & 10 & 11 & 12 & 13 have the same maximum value .. so if possible to deal with them all together)

Hope it is clear

Hi there Yasser!

I'm really in a hurry but I'll be back later. First thing though, for you to put values in a text box use the .Text property.

Please Login or Register  to view this content.

, not

Please Login or Register  to view this content.

Be right back!

Thanks a lot Mr. Bulina for reply
I will wait for your reply
The request is concerned how to restrict the entries of these textboxes (textbox1 to textbox13) ..some textboxes are similar in conditions of restriction

Any help in this topic please?

If you add this code to your user form's code module, that should work.

Please Login or Register  to view this content.

That's amazing Mr. mikerickson
I just need to emphasize that the letter "A" would be allowed along with the minumum and maximum values
I mean that the user may enter the letter "A" or 0 to 50 for textbox1 and so on with other textboxes

Just the letter "A" allowed along with the values ..
As for values everything is ok but I couldn't enter the letter "A" ..

It sounds like "A25" would be an acceptable entry. (assuming the cell imposed limit was large enough)

Would "A025" be acceptable?
Would "25" be acceptable?

I'm sorry for confusing
the entry would be either the letter "A" or a value between 0 and 50 ...(just two cases one for text possibility and the other case for a value between two sides "minumum and maximum"

Assuming that minimum < 25 < maximum:

Would "A25" be acceptable?
Would "A025" be acceptable?
Would "25" be acceptable?
Would "025" be acceptable?

A25 not acceptable
A025 not acceptable
25 is ok
025 not acceptable

Look I am dealing with marks for subjects and each subject has a mimnum and maximum value
At the same time , there would be some absent students so the user enter the letter "A" in this case
Hope it is clear now

This version of the addition should do what you want. (it is assuming that you will be entering integers only.)

Please Login or Register  to view this content.

Thanks again for this perfect version of the code
my last fix (I'm dealing with decimals not just inegers as the marks would be sometimes 20.5 or 25.25 or 33.75 and so on)

Also I need to display a message if the user entered any other letter except "A" ..as a kind of a lert
Regards

This version of NumericBox_KeyPress will do what you want.
I prefer just substituting an A entry to a warning msgbox. (User presses "B", "A" is entered in box). If you want that you can comment out that msgbox line.

Please Login or Register  to view this content.

Thank you very very much for this fascinating solution
Now it is perfect ...

Just last little point (Sorry for disturbing you)
I need to use an Arabic letter instead of "A" ..my letter is "غ" but when replacing "A" in your code with "غ" it appears in weird way in textboxes ..
Any idea about that

Change this section of the code

Please Login or Register  to view this content.

Great great
thank you very much
Can you provide me a tutorial of ChrW function as it seems very useful for me?
Just a remark (I promise to be the last) ..Why I have a message box even if I entered "غ" ..it is supposed that it is the default allowed letter so I don't expect to get the alert message
When I change the language input to type the letter "غ" I got error messsage at this line

Please Login or Register  to view this content.

I don't know what key results in that character, so I don't know how to test for it. The code is written to show the msgbox when other than "A" is entered. My style would be to remove that msgbox entirely.

Its a smoother interface to correct a user's mistakes (hitting the wrong key) rather than nagging them about it. Since there is only one alphabetic entry allowed, if the user attempts any alphabetic entry, the routine automatically enters the correct text. No nagging is needed.

Tutorials
https://msdn.microsoft.com/en-us/lib...(v=vs.90).aspx
http://dailydoseofexcel.com/archives...scw-functions/

Thanks a lot for the advice ..
You have done great effort in this thread ..thank you very much for your effort and time
Regards