Automatic Translation

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
 
J

Jim Rech

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.
 
L

link_xue

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
 
J

Jim Rech

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.
 
Top