+ Reply to Thread
Results 1 to 2 of 2

how to gain access to excel controls in english and other language version.

Hybrid View

zangyef how to gain access to excel... 10-27-2013, 06:21 PM
alansidman Re: how to gain access to... 10-27-2013, 06:41 PM
  1. #1
    Registered User
    Join Date
    03-25-2013
    Location
    Italy
    MS-Off Ver
    Excel 2003
    Posts
    1

    how to gain access to excel controls in english and other language version.

    Hello,
    maybe I have to study better vba programming but I'm not able to solve this problem by myself.
    I created the code that should activate the "rectangle" function of the commandbar "drawing". This is the code line that works well:

    Application.CommandBars("Drawing").Controls("Rectangle").Execute
    but, if I copy the code in a pc with excel in a language other than english the code doesn't work (in my case the language is italian). This is because the italian name of the control rectangle is "rettangolo". I thought to solve the problem by using the ID of the control (for the commandbar "drawing" and the control rectangle is 1111) so the code would work both in the english and italian version. But I was wrong.

    Application.CommandBars("Drawing").Controls(1111).Execute
    Where I'm wrong? I need to write the code that works in the two versions of excel...
    Thanks in advance to those who wants to help me.
    Last edited by alansidman; 10-27-2013 at 06:40 PM. Reason: Code tags added in accordance with Rule #3

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,705

    Re: how to gain access to excel controls in english and other language version.

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE] [/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



    (I have added them for you. Please read our rules and adhere to them in the future.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Access data is showing in different symbols unable to change the language to english
    By devraj.kgp in forum Access Programming / VBA / Macros
    Replies: 0
    Last Post: 11-14-2011, 05:40 AM
  2. Covert the text in the Excel from English to other language
    By abiram01 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-22-2009, 10:00 AM
  3. Windows version language and Excel version language
    By Jac Tremblay in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-01-2006, 11:10 AM
  4. Replies: 0
    Last Post: 05-02-2006, 07:55 PM
  5. [SOLVED] how do I change the language in Excel from Dutch to English?
    By Mies in forum Excel General
    Replies: 1
    Last Post: 08-23-2005, 11:05 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