Userform UI Language Customization

[yinkajewole]

I have some userforms created in English, how do I code it such that using an option button, I can switch / change all the text to another language?

 

[RoryA]

There is no simple option. You'd have to create a table of the correct text for each control so that you can switch between them.

 

[yinkajewole]

how you do mean?

 

[RoryA]

I mean that you will need a list of the controls and what their text should be.

 

[yinkajewole]

ok, can you please make a sample for me?

 

[RoryA]

No, not really.

If you make a list in a two column range with the control name in the first column and the text you want in the next column, then you need a loop something like this:

for each cell in range("A2:A10")
me.control(cell.value).caption = cell.offset(, 1).Value
next

If you have different types of controls (I've assumed labels and buttons) you'd need to adjust for that.

 

[yinkajewole]

can't the text be extracted from a text file instead of worksheet?
by the way, how do I address those ones in the msgbox?

 

[RoryA]

Yes it can, it just makes the code more complicated.

You'll have to deal with those individually.

 

[yinkajewole]

if you don't mind, can you create sample files and share them with me?

 

[RoryA]

Again, no. I'm afraid that's above and beyond the kind of thing I do on forums like this, as I don't have that kind of time.