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
'sender - name
strSenderName = InputBox("Please Enter Your Name.", "Enter Name")
'sender error handling
If strSenderName = "" Then
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...
Visit my site: http://www.drybonesuk.com