Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Language (Word 97 -SR2)

    I'm ignorant of how to make a language switch for a VBA app. Is there an easy way to allow a user to click a radio button and have all the commandbuttons, menus, etc. change to, say, Spanish?
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Language (Word 97 -SR2)

    I don't think so. VB has a LoadResStrings statement which allows you to load your control captions from a .RES file, but there doesn't seem to be an equivalent statement in VBA. John Green's Book, Excel 2000 VBA Programmers Reference, has an entire chapter written by Stephen Bullen that discusses international
    issues, but I think it focuses on VBA and Excel function dialects, which are much bigger hurdles than captions. <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q140/6/29.asp>Q140629</A> is also interesting. It appears to me that VBA is very fragile on international issues. Sorry for the bad report. --Sam <img src=/S/brainwash.gif border=0 alt=brainwash width=15 height=15>
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Language (Word 97 -SR2)

    Thanks Sammy.

    (p.s. I like your 2 Tim2:2 quote!)
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •