+ Reply to Thread
Results 1 to 3 of 3

Compile error: Syntax error

  1. 04-24-2011, 02:18 AM #1
    ttik
    ttik is offline
    Registered User
    Join Date
    09-26-2007
    Posts
    39

    Compile error: Syntax error

    Hi,

    I got a problem when I open the attached spread sheet. It shows "Compile error: Syntax error" message from Microsoft Visual Basic. Anyone can help?

    Cheers.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-24-2011, 09:22 AM #2
    Simon Lloyd
    Simon Lloyd is offline
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161

    Re: Issue: Compile error: Syntax error

    It compiles for me, the only issues i had was with an acrtivex control but thats because im viewing it in xl2003, one thing to note was you had design mode turned on?? other than that it seems ok.
    Not all forums are the same - seek and you shall find
    Reply With QuoteRegister To Reply
  3. 04-24-2011, 09:45 PM #3
    ttik
    ttik is offline
    Registered User
    Join Date
    09-26-2007
    Posts
    39

    Re: Issue: Compile error: Syntax error

    thanks for that.

    do you know how to change the currency (USD, EUR, GBP) to other currency that i want? like changing USD to AUD.
    I tried to change it in visual basic, but when i go back to spread sheet and changing the currency on the drop down list. i got error. looks like i have to make the changes on the sheet as well. how can i do that?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1