Numeric code in textbox

Here is a system I use. It evaluates each key stroke as the user types it in. If the key stroke is a number then nothing happens, but if the keystroke is a letter or it will remove give an error message and remove the keystroke.

I have created an example code for a UserFrom with two textboxes...you can incorporate into your code.

To test create a UserForm with two textboxes named TextBox1 and TextBox2 and copy and paste the following code into it.

Please Login or Register  to view this content.

This is the most that can be done...unfortunately you will need a separate change event for all text boxes there is no way around that to my knowledge.

Please Login or Register  to view this content.

You are welcome!
Please Add Reputation if you are satisfied and mark the thread as "Solved"

Hi jdasp49

You can do this by introducing a Class Module

is it possible to join all textboxes in just one code

See attached for an example.

Awesome @jaslake! Thanks for the tip!

Based on a request by @YasserKahlil...to only allow one period (".") in the text box
Change

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

I think

@YasserKahlil

Play with this in the Class Module...there's a better way but I'm using the OP's Code...

Please Login or Register  to view this content.