+ Reply to Thread
Results 1 to 4 of 4

Change language settings in VBA

  1. #1
    Forum Contributor
    Join Date
    06-14-2013
    Location
    jk
    MS-Off Ver
    Excel 2007
    Posts
    326

    Change language settings in VBA

    Hi all,

    We are all using language settings English (United States) at my office and i was wondering if, for one macro we use, the language could be set to Dutch in the VBA script, and when it's done running the macro it changes back to English (United States) at the end.

    Does anybody know this?

    Thanks for the help

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: Change language settings in VBA

    Why do you want/need to do that?
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    06-14-2013
    Location
    jk
    MS-Off Ver
    Excel 2007
    Posts
    326

    Re: Change language settings in VBA

    First when i used the macro, at the office we used dutch as regional setting which now has been switched to UK (US) because of the keyboard layouts.
    Instead of creating a new macro, which somehow needs the dutch layout for some reason, i just would like to switch language in the vba script if its possible.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: Change language settings in VBA

    As far as I know there are no language settings for VBA, it basically uses (American) English.

    Can you give an example of something that would need to be changed?

+ 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. Change Button language according to Language Settings
    By Meithom in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2015, 05:00 AM
  2. Change Language Settings in Excel
    By coder_arun in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2011, 05:06 AM
  3. VBA date format - language settings
    By Newbie_Nick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2010, 04:19 AM
  4. Excel File Language Settings
    By rythmgamer in forum Excel General
    Replies: 1
    Last Post: 03-23-2009, 08:46 AM
  5. Change Language Settings in Excel
    By coder_arun in forum Excel General
    Replies: 0
    Last Post: 08-23-2006, 08:57 AM
  6. Language independent Pivot settings
    By Claude in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2006, 05:45 PM
  7. [SOLVED] DDE and MS Office Language Settings
    By DDE_User in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-06-2005, 09:06 AM

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