Efficiency Question about formatting 20+ text boxes on a form

I just realized I also need to include a value check for Numerical input only.

Thanks for the reply.

Looks like it would cut out a bit of code...

...but where do I plug that in?

I tried to put it into the UserForm_Initialize(), it Kacked.


I'm still more than a bit of a noob at this.

It just occurred to me that what I need to do is a subroutine that I can call out from the "on exit" sub of the Text cells.

Something like:

Please Login or Register  to view this content.

Or something like that.. I'll start playing with it.

That works great!

one thing tho, after entering a non Number the text that pops in stays there on focus so it can become an endless loop of adding text/numbers

For my error checking I wanted to change the color of the box to a yellow for non numbers So I tried this:

Please Login or Register  to view this content.

Insta Kack.

BTW you were right, The #,### worked perfectly as intended till I borked the code with the coloring thing.

Still plugging away, tried this:

Please Login or Register  to view this content.

Still Insta Kack (might help if I actually read a book on this )

Marking this thread as Solved since the original problem has been solved.

Will start a new thread about the multiple conditioning.

Thanks to broro183 and protonLeah for their help!