View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Justin[_14_] Justin[_14_] is offline
external usenet poster
 
Posts: 17
Default Windows "Region & Languages" ComboBox Issue

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!!!