I am trying to hide a row based on a 'yes' or 'no' value in a cell on the same sheet:
Current code is:
Please Login or Register to view this content.
I am trying to hide a row based on a 'yes' or 'no' value in a cell on the same sheet:
Current code is:
Please Login or Register to view this content.
Last edited by arlu1201; 07-03-2012 at 08:47 AM. Reason: Use code tags in future.
That code works fine as it is. What issue are you facing? Are you getting any error?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
The value in the target cell is dependent on a dropdown list on another sheet - when I change the value in the dropdown sheet the target cell updates but the row does not hide. If I enter the yes/no manually in the cell the codes works fine.
You need to choose the selection change event for your code.
Done - still does not work.
Please Login or Register to view this content.
Last edited by mlion; 07-03-2012 at 09:29 AM.
Please put code tags in post 5. Check my signature. I did it for you in post 1.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks