Combobox not working for excel 2000, german language

[iscar_marius]

I have a problem that is driving me crazy, please help me.
I'm using excel 2000 with english language.
I made a excel file with VBA. In one sheet I create a combobox using control toolbar and is working just fine for my english version of excel.

I sent this excel file to a colleague that has the same version of excel but in german language. He can't use this combobox and I don't understand why. We use exactly the same version of excel 2000, the only difference is that mine is in english and his in german.

What can I do so my combobox will work for german language too?

Please help!

[snb]

Show more of your code...
Differences are e.g. ; instead of , as listseparator, decimal separator . or , etc.

[iscar_marius]

This is all the code for combobox1:

Please Login or Register  to view this content.

The combobox1 if filled with data from a range and by selecting a value in combo, some cells are copied in another location.

[iscar_marius]

First I had the problem that after protecting the sheet, it was impossible for me to use the autofilter. I found this solution for excel 2000 to solve this problem:

Please Login or Register  to view this content.

It worked-But I don't think that this affect the combobox.

Like I told for me (with english excel 2000) everything is working just fine.

[snb]

Populate the combobox when opening the file
Maybe this suffices

Please Login or Register  to view this content.

[iscar_marius]

Show more of your code...
Differences are e.g. ; instead of , as listseparator, decimal separator . or , etc.

I don't know what the separator is, as you can see from the code I'm not very advanced with VBA.

[iscar_marius]

Populate the combobox when opening the file
Maybe this suffices

Please Login or Register  to view this content.

Thank you for your answer.
Is impossible for me to populate the combobox only when I open the workbook, because I modify the range for the combobox with other code after the workbook is opened.

[iscar_marius]

In the german verision of excel 200 I can't even click the triangle from the combobox. It's like is locked or something.

[snb]

Because you need to populate the combobox only once it's better not to couple the populating to a combobox-event (like _click, _change, _beforeupdate, etc).
You could consider a separate commandbutton or a worksheet_event. (_doubleclick or _activate e.g)

[iscar_marius]

Because you need to populate the combobox only once it's better not to couple the populating to a combobox-event (like _click, _change, _beforeupdate, etc).
You could consider a separate commandbutton or a worksheet_event. (_doubleclick or _activate e.g)

I will try to use a worksheet event and I will come back with a result.

Still, I don't understand why for my english excel version the combobox is working just fine and for german version is not working. Is not the same excel in a different language !?