moving around a page

ozPATT · October 14th, 2005, 05:49 AM

hi again,

i am sort of getting the hang of this vba business now... thanks for all your help so far.

how do I go about changing the flow of how the code runs? for example, i would like to have an input box, where if the user clicks ok and the field is empty, it tells them that they must fill it in, and returns them to the input box so they can try again...

i thought it might be something like

Code:

'sender - name
    strSenderName = InputBox("Please Enter Your Name.", "Enter Name")
    'sender error handling
    If strSenderName = "" Then
        GoTo EmptySenderName:
    End If

EmptySenderName:
    MsgBox "You must enter a name to continue", vbCritical

which does work, but i don't know how to take it back to the input box...

thanks

patrick

Visit my site: http://www.drybonesuk.com

vemaju · October 17th, 2005, 02:42 AM

Hi Patric,

Here's one example how to keep asking SenderName

strSenderName = InputBox("Please Enter Your Name.", "Enter Name")
If strSenderName = "" Then
    MsgBox "You must enter a name to continue", vbCritical
    ' Loop here until user enters sendername
    Do Until strSenderName <> ""
        strSenderName = InputBox("Please Enter Your Name.", "Enter Name")
    Loop

End If

-vemaju