Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default Excel 2003 Visual Basic (List Box) in English not running in Germa

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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9,101
Default Excel 2003 Visual Basic (List Box) in English not running in Germa

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" wrote:

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.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default Excel 2003 Visual Basic (List Box) in English not running in G

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" wrote:

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" wrote:

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.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9,101
Default Excel 2003 Visual Basic (List Box) in English not running in G

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" wrote:

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" wrote:

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" wrote:

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.

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default Excel 2003 Visual Basic (List Box) in English not running in G

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" wrote:

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" wrote:

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" wrote:

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" wrote:

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.



  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9,101
Default Excel 2003 Visual Basic (List Box) in English not running in G

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" wrote:

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" wrote:

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" wrote:

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" wrote:

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" wrote:

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.

  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default Excel 2003 Visual Basic (List Box) in English not running in G

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.

"Joel" wrote:

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" wrote:

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" wrote:

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" wrote:

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" wrote:

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" wrote:

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Running Sybase Queries directly from Excel (using Visual Basic)` Galore Excel Programming 0 March 3rd 08 09:30 AM
Excel 2003 visual basic help shows nothing p45cal[_50_] Excel Programming 2 May 11th 07 11:27 AM
visual basic/conditional format problem in Spanish Excel, English VB Mike[_96_] Excel Programming 2 May 26th 06 05:53 PM
changing the visual basic in office 2003 to visual studio net bigdaddy3 Excel Discussion (Misc queries) 1 September 13th 05 10:57 AM
Stopping Excel after running visual basic in Access Bill McCaleb Excel Programming 4 April 4th 04 02:20 AM


All times are GMT +1. The time now is 08:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"