Validating data entry to multiple textboxes in a userform

Hello all,

Problem:
Cannot redirect the user back to the Userform to re-enter correct data into textboxes after a messagebox appears due to an incorrect entry.

Explanation:
1) The userform consists of thirty (30) textboxes that are categorized under separate frames based on the type of data (geometry, material properties...etc).

2) The userform consists of ten (10) checkboxes. Based on the selected number of checkboxes, a certain number of the textboxes are enabled for data entry that would be used further in the code for calculations. For example, if a user selects Internal Pressure checkbox, only 7/30 textboxes are enabled for data entry. If they select Internal Pressure and Buckling, 12/30 textboxes are enabled and so on.

3) The textboxes are error checked for 2 conditions: no value entered and a value of 0 entered.
a) If there are no errors, the textbox.value is then stored in a declared variable to be used for an initial calculation.
b) If there are errors, a message box is prompted but the code continues on with the incorrect entry regardless. (would like to redirect user here after every error).

5) The result of the initial calculation is range checked to see if it falls within a specified upper and lower bounds.
a) If there are no errors, the declared variable is used for secondary calculations.
b) If there are errors, a message box is prompted but the code continues on with the incorrect entry regardless.(would like to redirect user here again after every error).

6) The error check, initial calculation, range check and secondary calculation for each of the checkboxes are under one Sub, and are called when the Submit (in my case it is Compute) button is clicked.

I would like the code to redirect the user back to the form to input the correct data rather than continuing on. I have seen examples where Exit Sub is used but since I continue using the variables in the same Sub, it is not relevant. Only thing I can think of is maybe some sort of While loop.

Any help would be appreciated.

Thank you.

Here is a sample of the code (I cannot show the full code since there are confidential information but this example shows only one of the enabled textboxes). In this case the Private Sub Compute_Click() calls Sub UT_Compute() which calls Sub BP_UT():

Please Login or Register  to view this content.

6StringJazzer,

Thanks for your reply.

The code I have is very cumbersome (about 4500 lines long) and I cannot post it all but I will try to explain as much as I can. The portion I show is where the action is. The rest of it is just different variations of what I posted.

To elaborate more, the results from the secondary calculations are displayed in two locations: an excel worksheet and a second form showing outputs. The second form is displayed once the user clicks the Compute button. I am not hiding the input Userform as I would like the user to still look at their entries.

...the latter is done is an error-check function when the user clicks a Submit button

Are you referring to something like On Error GoTo or Resume Next?

after this code runs the user is still on the form, and I don't know what you mean by "continuing on."

I should have been clearer in using "continuing on" I meant the following happens when the user clicks the OK on the message box:
- If the error is the textbox being empty or having a value of 0, then the whole code crashes due to an error in calculation (usually division by 0).
- If the error is the textbox having a value outside the lower and upper bounds, the code still proceeds with the calculation and display the second form with results.

I hope this clarifies my points.

Even thought the code I posted does not close the form, it does not allow the user to re-enter values after clicking OK on the messagebox.

Ok quick update. I have figured out where my issue was.

I decided to remove the data entry check from Sub Bp_UT and rather include it in the Compute_Click(). I also had to add an Exit Sub after the message box to allow the user to go back.

I have also managed to a much more concise method of checking the data entry (since my textboxes are inside frames that are inside other frames) without having to repeat the same lines over and over.