VBA Stop message

[sherriwatkins]

Hi,

I am trying to create a code that will create a stop message if a field is left blank. I have a macro to go to the next page that I want to change. It is not working correctly and I don't know what I have done wrong. The caveat is there are 16 hidden cells that will highlight grey based on s selection on a previous page. If there is 1 machine, only one shows up, if there are 16, then all 16 show up. I need this code to work only for the highlighted fields. Here is my current code.
Application.ScreenUpdating = False
Sheets("11").Visible = True

If Worksheets("10").Range("A10") < 1 Then
MsgBox ("You must enter the length of cable for the Ethernet Cable between 0 and 330 feet.")
ElseIf Worksheets("10").Range("A10") > 0 Then
Sheets("11").Select

Range("A1").Select


Sheets("10").Visible = False
Application.ScreenUpdating = True

Please help!

 

[Scott T]

you can use exit sub to exit out of the sub then after the amount is entered the code can be run again.

If Worksheets("10").Range("A10") < 1 Then[INDENT]MsgBox ("You must enter the length of cable for the Ethernet Cable between 0 and 330 feet.")[/INDENT]
[INDENT]Exit Sub[/INDENT]
else 'rest of your code

 

[sherriwatkins]

You are awesome! Thank you so much for your help!

 

[Scott T]

Glad to help