Using option buttons to change standard form language

[MrNovice]

Hi,

I am developing a standard Packagaging Data Sheet for my Logistics Department.

It is currently in German, but I would like to implement a functionality to switch between German and English language via Excel Option Buttons - see current layout in the attached Excel file.

Preferably, the language switch function should only affect cells that have pre-determined form text in them (these will be locked in the final version), and not the cells that the user should fill out (grey colored cells).
Alternatively the sheet as a whole can be switched in order to simplify the functionality, but I guess that would erase any information already entered into the sheet...?

Of course the alternate language text would have to be stored somewhere, but I'm not sure wheather it should go on a hidden worksheet, directly into a macro function, or somewhere entirely else.

I am not sure how best to go about it, but I figure, that a macro is the way to go.
I am new to VB programming in Excel, and my knowledge about macros is very basic.

I hope someone on this forum is able to help!

Sincerely
Bo