Marco to change text of form buttons based on language

[Rocky2013]

Hi,
Need some help to change the text of button using marco based on language is choosen.

Thanks

[nilem]

Hi Rocky,
try it

Please Login or Register  to view this content.

[Rocky2013]

Hi nilem,
Perfect! It works if the reference in sheet1.

I moved the reference and content in cell A6 to sheet2.
In marco, I changed "A1:E3" to "sheet2!A1:E3", the code
does not work any more. Can you please take another look.


Thanks!
спасибо!

[nilem]

if the range of choice is on the Sheet2, change this line

Please Login or Register  to view this content.

[Rocky2013]

Thanks, it works now.

[john456852]

you should be sure to save workbook as macro-enabled or else it won't save the code. also, mark as solved