Re: stop script if dates are missing, edit help...

Tech-Archive recommends: Fix windows errors by optimizing your registry

I wrote this up to go after the:

On Error GoTo Finish

' If Dates are missing Print out a POP-UP Box to screen explaining
error

If DateValue(BeginDate) = "" Or DateValue(EndDate) = "" Then
MsgBox "Calculation can't be performed, missing Dates in selected Date
Range!"
GoTo Finish
Else
GoTo LastPart
End If

but not sure if this is good, what do you guys think ?

.

Relevant Pages

  • Re: error handling
    ... Sub test1() ... On Error GoTo MyError ... MsgBox "snafu" ...
    (microsoft.public.excel.programming)
  • Re: stop script if dates are missing, edit help...
    ... Ron has some instructions on how to use it on that same page. ... > On Error GoTo Finish ... > ' If Dates are missing Print out a POP-UP Box to screen explaining ...
    (microsoft.public.excel)
  • Re: Using ":" in coding
    ... and doesn't have some hidden meaning that is going to severely corrupt my ... I've noticed that if you are going to use the Goto ... I've always wondered why the Exit_fFunc and Error_fFunc lines have a colon ... On Error Goto Error_Function ...
    (microsoft.public.access.modulesdaovba)
  • Re: edit network script for window pop-up, store values... help..
    ... Sub FindWhatWeToldThem() ... On Error GoTo 0 ... GoTo StartOverOne ...
    (microsoft.public.excel)
  • Re: Delete All Blank Rows--A plea for help
    ... Try adding this code line just below the "goto 0" line... ... Some cells are text, some are numbers, and I've set ... Sub RemoveBlankRows() ... On Error GoTo 0 ...
    (microsoft.public.excel.programming)