Textbox if empty validation code

I have created the below userform.

userform.xls

When the textboxes are empty the label will change colour and indicate that the person needs to put value in the textbox.


I have about ten textboxes

What I can't seem to do is:
1) get all the labels that have textboxes empty to change coulour at one go, my Code seems to do the first one then go to the next.

2) can't get the label to change back to original colour when the textbox is not empty

Please help

Thanks

Please Login or Register  to view this content.

Hello Panic,

I change your code and placed the the "If" statements into the Exit event of the each [b}TextBox[/b]. The attach file has the changes already made. The user form code is shown below...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Leith Ross

Thanks for that, but exit code doesn't really work for me.

I will have 10 to 15 textboxes, spread acroos a multi-page, exit code will only work if they have the curser in the text boxes.

What I wanted was all the text boxes that are empty, have their labels turned red in the instance the save button is pressed.

Hence they will only press the save button once or twice, instead of the reminder message coming up every save or exit textbox.

I'll give an example "out of 10 textboxes, three are empty. Press Save, their corresponding labels need to change to red with a message coming saying the they need to complete all red labeled boxes"

I hope this clear

Thanks

Panic

That might work.

If the boxes are empty then they will be red but if the boxes have value they would be white.

what is the code for boxes not being empty

Please Login or Register  to view this content.

Thanks

Panic

Hello Panic,

This version of your file has 2 macros. One macro loads a control array that has the names of the Text Boxes and the Labels associated with them. The second macro will validate the entries using the control array. It will set focus to the first empty text box and change the label caption color to red.

You will need to expand the control array. There is one array for the text boxes and another array for the labels. These are combined to make the control array whose dimensions are 2, n. The first subscript (0, n) holds the name of the text box, and the second subscript(1, n) holds the name of the label for that text box. I have marked the code in red.
Module Code

Please Login or Register  to view this content.

Macro Module Code

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Hi Leith Ross,

This is excellent!!!!!

I added few comboboxes and it works, This code lets me select the boxes (controls) i want included in this validation

I'll see if I can use this code to empty all of the itemised boxes too

"Unless you can help"

anyway

Thank you very much

Panic