Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to have a macro simply issue the "find" command or "control f: | Excel Programming | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
How do I Unzip the files in "ExcelMap-China-Region.Zip" into your | New Users to Excel | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |