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

Do you examples of good/bad settings ?

NickHK

"TCook" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
>
>

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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Do you examples of good/bad settings ?
>
> NickHK
>
> "TCook" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> 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
>>
>>
>
>

Todd,
Sorry, XL2002 on W2K.
Don't have such a setting.

NickHK

"TCook" <(E-Mail Removed)> wrote in message
news:eI%(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > Do you examples of good/bad settings ?
> >
> > NickHK
> >
> > "TCook" <(E-Mail Removed)> wrote in message
> > news:%(E-Mail Removed)...
> >> 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
> >>
> >>
> >
> >
>
>

Hey Nick,

You are correct. Windows 2000 is different.

Todd


"NickHK" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Todd,
> Sorry, XL2002 on W2K.
> Don't have such a setting.
>
> NickHK
>
> "TCook" <(E-Mail Removed)> wrote in message
> news:eI%(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>> > Do you examples of good/bad settings ?
>> >
>> > NickHK
>> >
>> > "TCook" <(E-Mail Removed)> wrote in message
>> > news:%(E-Mail Removed)...
>> >> 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
>> >>
>> >>
>> >
>> >
>>
>>
>
>