ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Windows "Region & Languages" ComboBox Issue (https://www.excelbanter.com/excel-programming/372466-windows-region-languages-combobox-issue.html)

Justin[_14_]

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


Justin[_14_]

Windows "Region & Languages" ComboBox Issue
 
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!

Justin wrote:
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!!!




All times are GMT +1. The time now is 04:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com