Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Sorry everybody but when I thought I was getting to grasps with this it's all going down the hill.
The code bellow checks for; W17 which is a delivery date field. This is working correct. It displays message if date is in the past. Now the problem is, if date is in the past I get message and if ok then the macro runs to the next step and checks for cell AX17 processed by. Now if date is not in the past the macro does not carries on to check AX17, it just stops... Where in the code bellow am I going wrong please? Thank you. Albert Code:
Else If Range("W17") = Empty Then 'Checks if there is a delivery date. MsgBox "Please add a delivery date!", vbInformation, "Delivery date..." Range("W17").Select Else If Range("w17").Value < Date Then answer = MsgBox("The delivery date is set in the past." & vbNewLine & "Click OK if date is correct." & vbNewLine & "Click Cancel to change.", vbQuestion + vbOKCancel, "Delivery date!") If answer = vbCancel Then 'Exit Sub*****************------------------ Range("w17").Select Else If Range("AX17") = Empty Then 'Checks if there is who processed invoice. MsgBox "Please select Processed By!", vbInformation, "Processed by..." Range("AX17").Select Else If Range("AZ73").Value = 0 Then MsgBox "Invoice cannot be £0.00!", vbInformation, "Invoice total..." 'Checks invoice total must be greater than 0. Else Application.ActivePrinter = "doPDF v7 on DOP7:" 'Selects doPDF to genarate PDF file of invoice. ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "E:\Lusa\Generated Invoices\INV" & Range("L17").Text & ".pdf", _ Quality:=xlQualityStandard, IncludeDocProperties:=False, IgnorePrintAreas _ :=False, OpenAfterPublish:=False If Application.Dialogs(xlDialogPrinterSetup).Show Then End If |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code Stops Running Instead of Debugging | Excel Discussion (Misc queries) | |||
Macro stops running at an unexpected time | Excel Programming | |||
Excel VBA Macro stops running when another program is activated | Excel Programming | |||
why excel stops running?? | Excel Discussion (Misc queries) | |||
Macro stops running after file has moved | Excel Programming |