stephenlecompte

Observe the following: I have two objects - a control button with the name Command1 and a text box named txtBox.

Private Sub Command1_Click()

Dim A As Integer
Dim B As Integer
Dim C As Integer

If txtBox.Text = "" Then A = 0:txtBox.SetFocus

A = 1
B = 2
C = 3

End Sub

My problem with the above is that if there is nothing in the txtBox I don't want A=1, B=2, C=3. I want it to skip it without using the command ELSE!!!!
Because the above is just an example of something larger. I have about 30 code IF/THEN statements where A=1, B=2, C=3 are! Any ideas as to as to what is best is appreciated always!

Thanks,

Stephen

Legend

I'm not sure what you are trying to achieve - what's wrong with using Else?

Are all the if/thens for different textboxes? If you have lots of textboxes with similar code, why not just create a control array of textboxes, and code it once?

00100b

The best way is to use the full "If Then...ElseIf...Else...End If" construct, but if you are set on this method then:

Or if you have some other code below and before the End Sub, then place a line label and issue a GoTo.

stephenlecompte

Thanks for the help.

The A=1, B=2, C=3 represents multiple IF/THEN statements that based on data entry in several text boxes & check boxes would make certain fields visible or invisible to the users based on the options. Some text boxes in groups would be different in value than others even tho they are all in arrays.

The Exit Sub tip and Resume_Here really work well.