easy vba question

[Crash893]

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

[westconn1]

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

[anhn]

Make it clearer, you should write:

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].

[VBFnewcomer]

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)

[Hack]

Moved To Office Development

[Siddharth Rout]

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

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...