Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation List - adding new entries | Excel Worksheet Functions | |||
Data Validation...I need to add more entries!! | Excel Discussion (Misc queries) | |||
Excel formula that adjusts to new columns as entries made in cells | Excel Programming | |||
validation of textbox entries | Excel Programming | |||
Using Data Validation - how do I allow other entries | New Users to Excel |