Changes to entries made through validation
I have users select items from a validation list that dynamically displays
the list items in the language of the user's choice and then enters that item in the language selected. The problem is if another user changes the language for the spreadsheet, the entry made through the validation list remains in the original language. I've used two columns, one for the validation and another to allow the language to change for that entry. This is a bit awkward though. I've looked at the posts and the Contextures page, but not seen any similar difficulties. Thanks for any help Jake |
Changes to entries made through validation
When a user changes the language, why not have a macro run at that moment
that goes through all the data in the sheet and updates the language displayed. Or store the actual response in, say, English and have that column hidden and then have the display column do a lookup to the your language conversion table to convert your hidden English word and display the resulting language's word. Not sure this will help, but since it has been a couple days with no other responses, I thought I'd give it a try. "Jake" wrote: I have users select items from a validation list that dynamically displays the list items in the language of the user's choice and then enters that item in the language selected. The problem is if another user changes the language for the spreadsheet, the entry made through the validation list remains in the original language. I've used two columns, one for the validation and another to allow the language to change for that entry. This is a bit awkward though. I've looked at the posts and the Contextures page, but not seen any similar difficulties. Thanks for any help Jake |
All times are GMT +1. The time now is 08:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com