Hi All! I am new to VBA. I need help trying to use a checkbox to hide/or unhide rows based on a cell in that row. I have two checkboxes in a user form that appears when a command button is pressed on in the spreadsheet, “DG”, “BIA”. The values of the cells that determines if the row will be hidden or not is in column AB, it will either says “DG” or “BIA” (if DG is checked, then the row should appear if AB12 for example says “DG”). the entire table range is A9:AB36, row 9 being the headers.
Hello ldonis,
Welcome to the Forum!
Can you post your workbook? It will make it easier to answer your question.
How To Post Your Workbook
- At the bottom right of the Reply window, Click the button Go Advanced
- At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
- Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
- Click the Select Files button at the bottom middle of the dialog.
- In the new window Find the file you want to upload, select it, and Click Open.
- You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
- Wait until the file has completely uploaded before you exit the File Manager dialog.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Here you go
Last edited by ldonis; 09-11-2014 at 01:44 PM.
Hello ldonis,
Paste this code into your UserForm. It work fine for me. The attached workbook also has the code added.
Please Login or Register to view this content.
Re: User form/checkbox hide/unhide rows based on cell value
That's Great! It worked. I might have couple more questions on it later to make it work for about seven different check boxes and one for the subtotal line as well. Thanks for the help!
Thank @Leith Ross, It's usefull for me also.
hungtt7
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks