Automatic Translation

  • Thread starter Thread starter link_xue
  • Start date Start date
L

link_xue

Hello all
I am a new user here, having a question with the excle file attached
need your help.

This file is bilingual, when you click 'English' then all the info in
English, if you click 'German' then it be German. Its interesting to
me, but don't know how it works. Would anyboy share your tips with me,
thank you very much.

Link

Attachment filename: isr1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=384425
 
The worksheet is full of formulas like:

=IF(BA1=1,"Product with DwSpA","Produkt mit DmbA")

The option buttons are linked to cell BA1, 1 for English and 2 for German.

The unlocking password (Tools, Protection, Unprotect Sheet) is "ABL" if you
want to see the formulas.
 
Jim, thank you very much for the reply.
But how to let ba1 display 1 when you click 'English'? I didn't find
the relation betwen them. Tks! Link
 
Option buttons (from the Forms toolbar) can be linked to cells. If you
right-click one of the option buttons and pick Format Control you'll see the
"Cell link" on the Control tab.
 
Back
Top