ControlSource and Localization Issue?? (run-time error '380' Could not set the ControlSource proper

  • Thread starter Thread starter TCook
  • Start date Start date
T

TCook

Hello All,

I am having a problem setting the ControlSource property on a ComboBox.

For example:

Type some text in a cell and select it.

Add a userform to a VBA project and add this code:


Private Sub UserForm_Initialize()
Me.ComboBox1.ControlSource = Selection.Address
End Sub


When my Regional Options are set to English (United States) the above code
runs fine. However, if I change my Regional Options to German (Germany) I
receive the following error:

ControlSource and Localization Issue?? (run-time error '380' Could not set
the ControlSource property)

Please advise.

Thanks,

TC
 
Hallo TCook,
I am having a problem setting the ControlSource property on a ComboBox.
For example:
Type some text in a cell and select it.
Add a userform to a VBA project and add this code:

Private Sub UserForm_Initialize()
Me.ComboBox1.ControlSource = Selection.Address
End Sub

When my Regional Options are set to English (United States) the above code
runs fine. However, if I change my Regional Options to German (Germany) I
receive the following error:

ControlSource and Localization Issue?? (run-time error '380' Could not set
the ControlSource property)
Click to expand...

hier spricht man Deutsch

bei mir läuft der Code unter WIN XP SP2 XL2003 DE
Einwandfrei ohne Fehlermeldung

mfg Herbert
 
Back
Top