Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / May 2008

Tip: Looking for answers? Try searching our database.

Changes to entries made through validation

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jake - 27 May 2008 18:55 GMT
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
Mike H. - 30 May 2008 12:57 GMT
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.

> 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
[quoted text clipped - 6 lines]
> Thanks for any help
> Jake
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.