Hi All,
I think this is a pretty easy one, but I've tried everything I can think of and looked all over but I just can't crack it.
I have a very simple user form on my excel wb. It has one combobox and one command button.
What I wish to do is, based on the selection of 1-4 in the combobox, hide lines on a work book. The code I have so far is;
Do I have it in the wrong place? Or is it totally wrong?
Please Login or Register to view this content.
Thanks for any help.
Last edited by beenbee; 07-29-2014 at 05:23 AM. Reason: typo
Should this not be under the CommandButton1_Click()Originally Posted by beenbee
Hi All,
I think this is a pretty easy one, but I've tried everything I can think of and looked all over but I just can't crack it.
I have a very simple user form on my excel wb. It has one combobox and one command button.
What I wish to do is, based on the selection of 1-4 in the combobox, hide lines on a work book. The code I have so far is;
Do I have it in the wrong place? Or is it totally wrong?Please Login or Register to view this content.
Thanks for any help.
Code is okay but it appears to be in the userform click event procedure.
If you want the rows visibility to react to actually clicking the combobox you will need to move the body of the code in to the comboboxes change event
In response to "Should it not be on CommandButton1_Click()". Thank you for your response. I have tried but it hits me with an "Application-defined or object-defined error".
Last edited by beenbee; 07-29-2014 at 05:39 AM.
Same issue as stated to the previous poster, "Application-defined or object-defined error". However these cells are populated. Should I be referencing the range differently?
Actually try replacing Rows with Range and including EntireRow
Please Login or Register to view this content.
Fixed by removing the B's, thanks for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks