+ Reply to Thread
Results 1 to 3 of 3

Auto open Excel

Hybrid View

RinorM Auto open Excel 08-21-2014, 03:46 AM
buran Re: Auto open Excel 08-21-2014, 03:49 AM
RinorM Re: Auto open Excel 08-21-2014, 03:53 AM
  1. #1
    Forum Contributor
    Join Date
    04-28-2014
    Location
    Sverige
    MS-Off Ver
    Excel 2010
    Posts
    221

    Auto open Excel

    Hi,

    I have this code which auto opens a messagebox when opening Excel. I have pasted it in my module. But somehow it appears the following message and high lights the messagebox part:

    "compilation error - syntax error"

    Sub auto_open()
    
    MsgBox "För att få mer info om indata parametrarna klickar du på den cell som du vill veta information om. Om du exempelvis vill veta "Terrängtyp" klickar du på cell B20. "
    
    End Sub
    Thankful for any kind of answer.

    / Rinor

  2. #2
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Auto open Excel

    it's because of "

    it should be
    Sub auto_open()
    
    MsgBox "För att få mer info om indata parametrarna klickar du på den cell som du vill veta information om. Om du exempelvis vill veta ""Terrängtyp"" klickar du på cell B20."
    
    End Sub
    If you are pleased with a member's answer then use the Star icon to rate it.

  3. #3
    Forum Contributor
    Join Date
    04-28-2014
    Location
    Sverige
    MS-Off Ver
    Excel 2010
    Posts
    221

    Re: Auto open Excel

    Worked fine, thank you.

+ 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. Auto open excel for every 30minutes
    By bujji1305 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2012, 01:40 AM
  2. How To Auto Open Outlook from Excel
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-20-2011, 01:05 PM
  3. open up an excel program with an auto open macro
    By john.9.williams@bt.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-17-2005, 12:05 PM
  4. excel VBA for auto open PowerPoint
    By Duncan_J in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-26-2005, 05:19 PM
  5. [SOLVED] Auto Open Excel
    By David Kemp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2005, 10:06 PM

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