Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.de.excel,microsoft.public.excel.programming
|
|||
|
|||
ControlSource and Localization Issue?? (run-time error '380' Could not set the ControlSource property)
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 |
#2
Posted to microsoft.public.de.excel,microsoft.public.excel.programming
|
|||
|
|||
ControlSource and Localization Issue?? (run-time error '380' Could not set the ControlSource property)
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) hier spricht man Deutsch bei mir läuft der Code unter WIN XP SP2 XL2003 DE Einwandfrei ohne Fehlermeldung mfg Herbert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ControlSource Property Throwing Errors After Changing Regional Settings | Excel Programming | |||
Run time Error 380. Could not set the ControlSource property | Excel Programming | |||
Could not set the ControlSource property. Invalid property value error | Excel Programming | |||
Syntax for TextBox ControlSource Property to another worksheet | Excel Programming | |||
Textbox ControlSource Property - Excel 97 | Excel Programming |