I have a macro in the drop down boxes that hide & unhide columns... i wish I could say I did it myself but I didn't. I was looking over my sheet & went back to add another option. As you can see in the 2nd drop down box named "Number of related accounts:" the "0" option does not work. I get an error. I want "0" to be an option for those that use this sheet but I don't want anything to unhide...
Last edited by jgomez; 08-21-2012 at 04:33 PM.
Hello there,
Try updating the Private Sub ComboBox2_Change() Event to look like this:
I have highlighted the change to make the 0 work
Please Login or Register to view this content.
Thank you... how or where do you learn to write this language or whatever its called?
Hello there,
Google has been my friend when learning Visual Basic, I just kind of picked it up as I had questions or others had questions.
Below is an attempted break down of the code you have in your workbook, green are comments.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks