Hi,

our project needs few wordlists to be checked and corrected. A retired Prof. for linguistics is ready to do that for us. But the problem is that he is 75 years old and has very little experience with computers, specially with excel. His eyes are very weak and he can only edit the lists if they are in big font size. The lists should also be in clear and transparent order so that he can easily understand and edit them. We have been working with him for over two years but he forgets things and many times he has just lost the whole list. A painful situation for both the parties each time. The other problem is that he is in another country and we cant assist him directly but only through phone.

For the solution of the named problem we need a Userform for MS Excel. Lets call this userform "Dictionary Editor". The columns of a sheet are supposed to be made editable through a userform. This form is supposed to be opened in full screen as soon as the excel file is opened.

As far the different cells contain content in different languages, the needed keyboard layouts and fonts for the cells are different as well. Changing the keyboard for different languages confuses the Prof each time. Therefore the keyboard and font should automatically be changed if its needed for a column. For example in Column C there is always Phonetic/transcription which can only be typed by a specific transcription keyboard (for example: English keyboard layout for Newzealand) and the content of it can only be shown by a specific font (DoulosSILR.ttf). So if the textfield in userform corresponding to the Column C is activated, the keyboard and layout should automaticaly change to (Keyboard=English Newzealand; Font=DouosSilR.ttf).

Is it possible to upload the excel file automatically to a specific ftp server, if the prof is online? that way we could always recieve the latest version of his work. And if he delets or losts the file, we will be having the last version and not the whole work will be lost.

I am uploading the image of a userform, how we think it could look like. And there is also an excel file containing the userform. I hope that the image of the userform could solve the remaining quetions. If not please let me know.

Our project will be very thankful if you guys could help us out with that.

Thank you very much for each answer and guidance in advance.

Userform Image

Excel File containing the userform

P.S. our project provides free online dictionaries without any financial interest. http://www.qamosona.com