Hi, could somebody write a VBA script that does the following please?
- If 'Yes' is selected in A1 (Sheet 1), row 3 is shown in Sheet 2; if 'No' is selected, row 3 is hidden.
- If 'Yes' is selected in A2 (Sheet 1), row 5 is shown in Sheet 2; if 'No' is selected, row 5 is hidden.
Both A1 and A2 will be 'No' upon opening the spreadsheet and the rows will be hidden by default (I don't know if this is significant or not).
Thank you very much!
paste this on sheet1;
Please Login or Register to view this content.
Please click the * Add Reputation if this helps
If solved remember to mark Thread as solved
"I'm glad to help and this is not meant to sound smart, but either you have super-human vision to see all those controls cleared one by one with the code I posted, or your computer is really slow."
In addition to Blokeman's code, add this to the Workbook_Open Event
to take care of this part of your requestPlease Login or Register to view this content.
Both A1 and A2 will be 'No' upon opening the spreadsheet and the rows will be hidden by default
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thank you both! They work perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks