View Full Version : ComboBox crashes in 2002, SP3 but works fine in 2010
I have a ComboBox in Excel worksheet and VBA code associated with. The code is crashing in Excel 2002, SP3 but works fine in Excel 2010.
Any help will be greatly appreciated.
SJM
lucas
12-06-2010, 10:18 AM
Why not use data validation on the named range instead of code? I don't have 2002 but there seems to be a problem with something in the code when you run it so avoid it...
see attached
Why not use data validation on the named range instead of code? I don't have 2002 but there seems to be a problem with something in the code when you run it so avoid it...
see attached
Thank you for taking time to respond. I appriciate your help.
The worksheet that I incldued was a simplified version to explain the problem. Yes, I could use the DataValidation. However, some of my data are too long to fit in the DataValidaton dropdown list. And, I understand I can make the column wider temporarily. I have done my homework on the subject and thought the Cobmobox was more flexible to manipulate. I was hoping someone else would have come across the problem and may have the solution. By the way I am using the method suggested here: http://www.contextures.com/xlDataVal14.html (http://www.contextures.com/xlDataVal14.html)
SJM
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.