tpoynton
07-03-2007, 06:42 AM
Greetings! I am going to be updating an add in over the next few weeks, so I expect to be posting here a bit!
I have an add in that allows users to define and/or use a predefined language. I have all the translations in a worksheet, and a userform where users select their language. Since I dont speak Spanish or Albanian, this makes updating things quite cumbersome...
gLang = ThisWorkbook.Sheets("lngTrsl8").Cells(1, 15).Value
MsgBox ThisWorkbook.Sheets("lngTrsl8").Cells(409, gLang).Value
This is how I populate all text on userforms, worksheets, messageboxes, etc. gLang is a global variable, and when each userform, function is called it sets the column to find either English or another language.
I am now going to revert to an English-only version, so I can stay on top of updating. I'd like to know if there is a way to programmatically change the code in the VBE to the text in each designated cell in the workbook.
I've attached a sample workbook showing how the worksheet is structured.
Hope this makes sense! there are about 500 references like this, and I'd really like to not have to retype everything...THANKS!
I have an add in that allows users to define and/or use a predefined language. I have all the translations in a worksheet, and a userform where users select their language. Since I dont speak Spanish or Albanian, this makes updating things quite cumbersome...
gLang = ThisWorkbook.Sheets("lngTrsl8").Cells(1, 15).Value
MsgBox ThisWorkbook.Sheets("lngTrsl8").Cells(409, gLang).Value
This is how I populate all text on userforms, worksheets, messageboxes, etc. gLang is a global variable, and when each userform, function is called it sets the column to find either English or another language.
I am now going to revert to an English-only version, so I can stay on top of updating. I'd like to know if there is a way to programmatically change the code in the VBE to the text in each designated cell in the workbook.
I've attached a sample workbook showing how the worksheet is structured.
Hope this makes sense! there are about 500 references like this, and I'd really like to not have to retype everything...THANKS!