Excel 2003 Visual Basic (List Box) in English not running in Germa

[Lily]

We developed an application in Excel 2003 with Visual Basic codes in English.
Our German prospective user has problem with the List Box. The user is
supposed to select chemical ions from the Selection box to the Selected Box.
The ions could be selected or deselected to/from the list box. Selected ions
are then transposed to a Table on the Worksheet. This is working in the
English version. However, the user seem to have problems in selecting &
deselecting some of the ions. Is there any special procedure without actual
translation on our part for the English version to work properly in the
german version.

The password input box is worikng.

Appreciate any help in this matter.

Thanks.

 

[Joel]

I think you need to isolate the problem futher. It is strange that some of
the IONs can be selected and others can't. Are you using some change event
to automatically move the selected item to the box or are you using a button.

If you have a change event I would add a message box in the change event to
help isolate the problem. See if the problem is the event stopped working or
if there is problems moving the data.

I'm thninking that the events are disabled because of some error, or the
German version isn't recognizing a change in the selected item. If two IONs
get translated to German to the same Text then the German version may not be
recognizing the Text has changed.

 

[Lily]

Joel,,

It seems strange too. Since I do not have a German version I can not really
isolate the problem. We run the program using a Japanese version and there
was no error. In fact my first thought was the interpretation of the
subscript & superscript which I did not use in this case.

The VBs are a simple upload and selections for placement on another
spreadsheet where I do all the calculations.

One thought that came into mind is the Reference Library. I used the Visual
Basic for Application, MS Office Excel Object Library, Microsoft Forms. I
suppose if the version are different, that would cause a problem.

Thanks for your response.

 

[Joel]

There are registry items that are used for diffferent countries. Don't know
if that is a problem. I had a problem where somebody form Israel was sending
files to turkey and the test was coming out right to left instead of left to
right.

I would check in the workbook the tools - Options - Spelling and see if nay
options are checked.

 

[Lily]

Joel,

Is that option in Spelling only for International Version? I do not have
that on my Excel version (English).

I'll let you know what's the problem after we get together with our
counterpart and resolve this issue.

Again I really appreciate your help.

 

[Joel]

I'm not sure. On my English version they are grayed out. I often check the
options to see if the are items im not familar with when I have International
problems.

 

[Lily]

Thanks Joel.

I will peruse on the International options. I saw the option you were
talking about right to left instead of left to right.

Have a nice day.