Editing columns through Userform; "Dictionary Editor"

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

Hi Wali,
where can i get the transcription keyboard?

thanks

Could we split the job into a couple of doable stacks.

- Job #1: Create the base userform with the capabilities to be loaded from the worksheet and ability to edit the worksheet from the form.

- Job #2: Work out the font and keyboard layout coding

- Job #3: Work out how sharing is going to be managed

So for Job#1 please find a first shot attached, please comment, and someone who is more fit about fonts could take it on now.

Some functionalities are not yet programmed, e.g. is it the abbreviation of the grammatical tickboxes necessary?

Also please, if you could group the tickboxes so that some can be changed to OptionButtons: to avoid ticking contradicting options in the same time.
Feel free to specify further functionalities.

Cheers, Gabor

Hi Gabor,
thaaank you very much. And i thought the thread will remain unanswered. Thank you very much. It looks really very good. I am sooo thankful to you that you took the time to solve it.

Unfortunately i cant load bigger list. We have to put over 60 000 words in it. I am uploading an excel file which contain a bigger list and the form cant handle it.

It would be great if the form could also work with bigger lists like this one:

bigerlist



Gabor,
1) is it possible to increase the number of languages? At least 18 languages?
2) Is it possible to make the form in fullscreen?

Thank you very much once agian. It will be very kind of you if the code is commented as much as possible. That would help others to help us update it latter ! :-) I hope that some one can solve the problem with fonts, keyboard layout and uploading as well. That would be really a good beginnig of new year for me! ;-) Though it already has started very well. Sending the latest version of the wordlist from Userform as email per one click would work for us as well.

Julia!
you can download the transcription keyboard from our homepage: www.qamosona.com If you need further guidance please contact me. I also have transcription keyboards for other languages.

Hi Wali,

If you want to handle a bigger list I'm afraid you need to turn to Access or some even stronger database.
My way of userforms have never been tested up to the limits of Excel: maybe up to 2-3000 records. Above that size the thing slows down.
In case you want the Prof not to lose the work you'd better off getting some oracle or pearl database jigged up for you by professionals that can be loaded online.
In case you want to stay with Excel then
1. go up to 18 languages: no problem
2. fullscreen: In the meantime I modified the form to be exacly 1024 x 768, that is my screen. What is the screen size of the Prof ? It's pointless to go beyond that.
3. comments: well, that would be the size of a book almost. What you've got from me is a patchwork of all the codes of all the good people GOD BLESS THEM ALL, who helped me out with bits and pieces of solutions mostly here in this forum !!! Many Thanks to Them. So to the comments: big job, honestly I do not want to take it on. I'd rather receive some messages from you guys here on the forum and adjust bits and pieces every now and then.

So, please post the rest of the languages and the screen size and we go from there.
I am not at my machine so I will look at your list later on this week.

Cheers, Gabor

Some integer restrictions lifted: now works with longer list.
Pls refill with your content. Content removed in order to be able to attach.
Note the layout of your table will not suit the Form. one column offset.
Please respond to screen size.
Please note tnew Commandbutton to fill ListBox1 with the content.
Be patient: will take a while to fill all 60000plus records.
Gabor