+ Reply to Thread
Results 1 to 2 of 2

code generating compile error: syntex error

  1. #1
    Registered User
    Join Date
    11-10-2013
    Location
    kolkata
    MS-Off Ver
    Excel 2003
    Posts
    3

    Post code generating compile error: syntex error

    my code is given below..i am using 2010 version of excel
    Sub GuessName()
    Msg = “Is your name “ & Application.UserName & “?”
    Ans = MsgBox(Msg, vbYesNo)
    If Ans = vbNo Then MsgBox “Oh, never mind.”
    If Ans = vbYes Then MsgBox “I must be clairvoyant!”
    End Sub

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: code generating compile error: syntex error

    It looks like you're using curly quotation marks:
    Please Login or Register  to view this content.


    Try using straight quotation marks:
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Compile Error in Hidden Module and Compile Error: Can't find project or library
    By Taislin in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-10-2013, 07:03 PM
  2. [SOLVED] Error Msg: "Compile error: Method or data member not found" in VBA code
    By nenadmail in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2012, 02:12 AM
  3. Syntex Error with IF, AND, OR statement
    By siamadu in forum Excel General
    Replies: 8
    Last Post: 06-09-2010, 04:30 PM
  4. VBA - Formula generating "Compile error/ Syntax Error"
    By arvin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-03-2009, 03:28 PM
  5. Syntex Error ??
    By Paul Cooke in forum Excel General
    Replies: 4
    Last Post: 12-09-2005, 09:54 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1