How to Decipher Compile error: Syntax error

Charlie07 · May 31st, 2013, 02:12 PM

This code is copied straight from the book Lesson 25 - Using Dialog Sheets

Code:

 Set dlgShowMessageOnce = ActiveWorkbook.DialogSheets.Add With dlgShowMessageOnce

This macro won't run because of the following Error Message:

Compile error: Syntax error

Please advise!

ozzz · August 23rd, 2013, 10:07 AM

comment it out and see what happens
ie put an apostrophe at the start of the line
we would need to know what sort of item dlgShowMessageOnce is.
i dont know about dialogue sheets unfortunately, but its trying to add 1.