Hi, I have tried many different ways of doing this, but I can't quite nail it. I am creating a form for colleagues to use and depending on their selection in the drop down list, I want to be able to hide a group of rows at the bottom of the form. I have tried VBA and Macros but I don't think I am getting the coding right.
Thanks for your help!!
Hi, I have attached the spreadsheet. What I basically want to do is if they click in C4 and select "Online - Brisbane" or "Online - Perth" the rows 61:66 are hidden so they don't fill them out. Alternately, if they select the other 2 options, they aren't hidden.
Thanks.
Last edited by Kim_Mohler; 05-02-2012 at 05:44 PM.
So I have input the following:
Which has worked for hiding the required rows, however I can't get them to unhide if, once selected, they want to change their option to one of the other 2.
Please Login or Register to view this content.
Last edited by davesexcel; 05-02-2012 at 06:57 AM. Reason: code tags required, please read the Foum Rules
See if this works.
Please Login or Register to view this content.
You are an absolute champion! It works. Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks