Help please, VBA userform, MsgBox!

Closed
Report
Posts
10
Registration date
Thursday September 17, 2015
Status
Member
Last seen
September 30, 2015
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello.

I have a userform that I use to introduce some data on excel.

Most of the data must be filled (that are textbox that the verifications dont need the information to do the calculations), because if they are not filled the rest of the worksheet cant do the verifications that I need.

When I click on the button "insert data",the textboxs that are mark with the red spot must be filled, if one of those textboxs aren't filled a msg box appears and says "Some data are missing, so the data can't be introduce on the worksheet".

So, I need to program the button insert, to only insert if the labels with the red spot are filled, and if they aren't filled to show me a msgbox.

Please, please, can anyone help me?

Thanks!

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
not sure if i am getting you. seems to be that you want to validate data before you insert

so why not have a check there to see if the text box is filled. since you know what boxes needs to be filled before hand