Hello,
I keep getting the "object doesn't support this property or method" error for the code below and I can't figure out why. Any help is appreciated. Thanks.
Please Login or Register to view this content.
Hello,
I keep getting the "object doesn't support this property or method" error for the code below and I can't figure out why. Any help is appreciated. Thanks.
Please Login or Register to view this content.
May we know what line generates the error?
Entia non sunt multiplicanda sine necessitate
Which line of code is highlighted when you DEBUG?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
My apologies. The line "Worksheets("Step 2").TextBox23.Visible = False" is highlighted yellow.
That means you don't have an ActiveX control on that sheet with that name.
I think there is another issue because there is an ActiveX textbox on that sheet with that name. And after stopping the debuging process, the textboxes become hidden and unhidden based on the value in u10, so the code appears to be working in some fashion.
I figured out why the error is occurring. I changed the style of ComboBox1 to "2 - fmStyleDropDownList." Does anyone have a workaround that will allow me to keep the "DropDownList" style and not get the error?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks