i have 7 ComboBoxes (CB) on my unprotected spreadsheet. When I go through the various Cases for CB6, it works perfect. However, when I go to any Case on CB2, I get this error and the Debugger highlights the line indicated below in CB6????? If I delete CB6, CB2 works perfect. I don't understand. Anyone have any suggestions
Thank you for your time!!!!
Please Login or Register to view this content.
Last edited by Tholmq; 07-16-2018 at 08:04 PM.
Check to be sure that row 51:101 are not already hidden. If they are, the rows already being hidden could be causing the error.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
You could just put:
at the head of your codePlease Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Your example file is missing and your code is not between codetags.
Originally Posted by Vraag en antwoord
Hello Vraag,
Attached is the file. Also, I am not sure what codetags are.
Ty
I tried this but it didn't work. Rows.Hidden=False
Ty
Mouse over the # which is above the box where you type and you will see it says "wrap [ code] tags around selected text"
if you press that while selecting your code it will apply code tags.
it makes the forum tidier (and easier for people helping you to select code) so it is one of the forum rules.Please Login or Register to view this content.
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
Here's how to do the code tags:
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
*Your routines didn't fail??
i apoligize. I forgot about codetags. I fixed it
Ty
You will notice that if you click on ComboBox2, the error occurs in the code for ComboBox6. When you change a value in ComboBox2, it causes a Change event in ComboBox6. This is happening because you are hiding rows 7:10 when there is a change to ComboBox2, and the ListFillRange in ComboBox6 is set to M1:M8.
The solution to this is to put the list values that you have in M1:U8 onto another sheet, and update your comboboxes accordingly. You should always separate working data vs. parameters.
That makes sense. I will try that.
This fixed my problem. Thank you so much!!!!!
Glad to hear it! You're welcome! Thanks for the rep, and thanks for marking your thread Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks