| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba
|
|||
|
|||
ControlSource Property Throwing Errors After Changing Regional Settings
Hey Nick,
Turn all of the Regional Settings to English except for the "Standards and Formats" setting which you can turn to German. Configure this way should cause the ControlSource property to fail. Regards, Todd "NickHK" wrote in message ... Do you examples of good/bad settings ? NickHK "TCook" wrote in message ... Hey All, I have been given the difficult task to taking a legacy VBA Excel solution and attempting to localize it. There is heavy use of the ControlSource property for ComboBoxes, TextBoxes, etc. Unfortunately, under certain Regional Settings configurations, this property throws an error and cannot be set. I am running WinXP SP2 w/ Office 2003 Pro. Has anyone had similar experiences with this property? Any proposed resolutions? Thanks In Advance, TC |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba
|
|||
|
|||
|
ControlSource Property Throwing Errors After Changing Regional Settings
Todd,
Sorry, XL2002 on W2K. Don't have such a setting. NickHK "TCook" wrote in message ... Hey Nick, Turn all of the Regional Settings to English except for the "Standards and Formats" setting which you can turn to German. Configure this way should cause the ControlSource property to fail. Regards, Todd "NickHK" wrote in message ... Do you examples of good/bad settings ? NickHK "TCook" wrote in message ... Hey All, I have been given the difficult task to taking a legacy VBA Excel solution and attempting to localize it. There is heavy use of the ControlSource property for ComboBoxes, TextBoxes, etc. Unfortunately, under certain Regional Settings configurations, this property throws an error and cannot be set. I am running WinXP SP2 w/ Office 2003 Pro. Has anyone had similar experiences with this property? Any proposed resolutions? Thanks In Advance, TC |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba
|
|||
|
|||
|
ControlSource Property Throwing Errors After Changing Regional Settings
Hey Nick,
You are correct. Windows 2000 is different. Todd "NickHK" wrote in message ... Todd, Sorry, XL2002 on W2K. Don't have such a setting. NickHK "TCook" wrote in message ... Hey Nick, Turn all of the Regional Settings to English except for the "Standards and Formats" setting which you can turn to German. Configure this way should cause the ControlSource property to fail. Regards, Todd "NickHK" wrote in message ... Do you examples of good/bad settings ? NickHK "TCook" wrote in message ... Hey All, I have been given the difficult task to taking a legacy VBA Excel solution and attempting to localize it. There is heavy use of the ControlSource property for ComboBoxes, TextBoxes, etc. Unfortunately, under certain Regional Settings configurations, this property throws an error and cannot be set. I am running WinXP SP2 w/ Office 2003 Pro. Has anyone had similar experiences with this property? Any proposed resolutions? Thanks In Advance, TC |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Could not set the ControlSource property. Invalid property value error | Excel Programming | |||
| ControlSource Errors with 2-Column ComboBox | Excel Programming | |||
| Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
| Controlsource errors | Excel Programming | |||
| Changing Regional Settings from VBA | Excel Programming | |||
Hybrid Mode
