Windows "Region & Languages" ComboBox Issue

J

Justin

Hi,

I am changing regions from Windows Control Panel to European Regional
Languages (where the ,'s and .'s are switched) and a strange event is
causing an error when I switch to any European country.

I am getting the error:

Run-time error '438':
Object doesn't support this property or method


If you click "Debug" it goes to the code in the private sub below:

Private Sub ComboBox1_Change()

Worksheets("Worksheet1").Cells(13, 5).Value =
UserForm1.MultiPage1.Pages(1).MultiPage3.Pages(0).ComboBox1.Value

End Sub


This works fine in English (United States) but fails in any region that
reverses the ,'s and .'s. Any ideas?

Thanks!!!
 
J

Justin

Solved my own problem - I went into the ComboBox properties and got rid
of the Control Source setting there, as it was unnecessary. Now it
works fine!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top