vba message box if yes/no

[Crispy85]

Hi,

I'm feeling pretty stupid now. I use this macro in another workbook and it works fine, but in the workbook im now working in it gives the error: Compile error, Else without If.

* "mappingfromfirstfile" is a macro
Whenever "No" is clicked, it just doesn't have to do anything.

Please Login or Register  to view this content.

someone knows what im doing wrong?

[NeedForExcel]

Try this -

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Crispy85]

Yes! Cool,

Do you mean that position really was the problem?

[NeedForExcel]

someone knows what im doing wrong?

If you write the If statement like this, If answer = vbYes Then mappingfromfirstfile, (Single Line Syntax) it does not require End If, and hence its giving that error.

If you are going to use If with End If, then you should have If answer = vbYes Then on Line 1 & mappingfromfirstfile on Line 2..

Hope this helps..

[Crispy85]

Ok thanks for the clarification!

Regards,
Crispy

[NeedForExcel]

Please mark the thread as solved if you have your answer..