![]() |
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!!! |
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