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

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

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