+ Reply to Thread
Results 1 to 7 of 7

How to change VBA code language to english??!?

Hybrid View

77anders How to change VBA code... 02-11-2009, 06:26 AM
royUK Re: How to change VBA code... 02-11-2009, 06:40 AM
77anders Re: How to change VBA code... 02-11-2009, 06:43 AM
Andy Pope Re: How to change VBA code... 02-11-2009, 06:59 AM
77anders Re: How to change VBA code... 02-11-2009, 08:10 AM
royUK Re: How to change VBA code... 02-11-2009, 08:14 AM
77anders Re: How to change VBA code... 02-11-2009, 08:18 AM
  1. #1
    Registered User
    Join Date
    12-22-2008
    Location
    Sweden
    Posts
    56

    How to change VBA code language to english??!?

    Hi,
    I jsut bought office 2007 but when I record a macro the VB code is in Swedish instead of english!. I've jsut learned most of the english commands so this is very confusing!!

    How to change the VB language to english?!?!?

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: How to change VBA code language to english??!?

    What's the language setting on the computer?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    12-22-2008
    Location
    Sweden
    Posts
    56

    Re: How to change VBA code language to english??!?

    Hi,
    WIndows XP =english
    Office 2007, menus etc is in swedish. I've changed teh lanugage settings in office 2007 to english but it jsut seem to adjust the spelling check when writing normal text....

    I guess it has to be done in the Visual basic editor but I can' find it....

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: How to change VBA code language to english??!?

    Office button > Excel Options > Popular > Language settings.

    You can use the "What This" button to get more help on what's effected.
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    12-22-2008
    Location
    Sweden
    Posts
    56

    Re: How to change VBA code language to english??!?

    Hi,
    I'v etried this and the only possibility is to change teh editing language (Spell checking). It soesn't affect the language that wxcel used to write code into VB editor...

    ANyone?

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: How to change VBA code language to english??!?

    Are you sure that you have an English version of Office?

  7. #7
    Registered User
    Join Date
    12-22-2008
    Location
    Sweden
    Posts
    56

    Re: How to change VBA code language to english??!?

    it's a swedish version but on my old office 2000 version, teh vb code was in english in the vb editor for macros etc...

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1