GoTo statement question

P

Patrick C. Simonds

Is there any way to have my GoTo statement goto a label that is defined in
my UserForm1 code? UserForm1 is active when the code below is run.


Sub MissingDataTest()

With UserForm1

If .Frame1.BackColor = &H80FFFF Then
msgbox "Sorry but you must enter a Status for this no show. Ensure
that all other Yellow fields are completed."
.MultiPage1.Value = 0
.Frame1.SetFocus
GoTo MissingData
End If

End With

End Sub
 
P

Patrick Molloy

GOTO are horrible IMHO, and their only use, regretfully is for the ON ERROR
statement.
So having got that off my chest ;)
Yuu could make MissingData a subroutine. There's no subsequent code, so when
it returns it wan't be an issue.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top