easy vba question

My boss wants to do this in her code

If CurrentTitle = "DOM" Or "USA" And HeaderNum = "2" Then

If prev = "EAST" And vari = "FOLIO" Then

MakeChanges2_9

Application.StatusBar = "2_9Using EAST Zone FIRST Edition as source for FOLIO Zone"

End If

End If

but its getting a syntax error on the or

I think it should be


If CurrentTitle = "DOM" Or CurrentTitle = "USA" And HeaderNum = "2" Then

but i don't have anything to compile vba so if some one knows for sure then please let me know

you do not need to compile vba to exe, it jut runs in the code windows on excel, word or other office application

but your solution looks correct

Make it clearer, you should write:

Code:

---

If (CurrentTitle = "DOM" Or CurrentTitle = "USA") And (HeaderNum = "2") Then

---

From VBA (in Access, Excel or Word, ...) you cannot create EXE but you can compile the code from menu [Debug]>[Compile VBA Project].

as your poser relates to VBA PM mods to move the post to office dev page so that you might get more responses (if you have not already got your solution) :wave:

Moved To Office Development

Like Anhn suggested, your code should be clearer to read. you can further clean it up and write it as...

vb Code:

Sub test()
 
If (CurrentTitle = "DOM" Or CurrentTitle = "USA") And (HeaderNum = "2") _
And (prev = "EAST") And (vari = "FOLIO") Then
 
    'use "Call", if it is a sub
    Call MakeChanges2_9
 
    Application.StatusBar = "2_9Using EAST Zone FIRST Edition as source for FOLIO Zone"
 
End If
 
End Sub

Hope this helps...