Hi,
In column S I have reference cells which return 3 values: "ToggleTrue", "ToggleFalse", and "Hideme". Based on input from another Workbook, these reference cell values change from day to day. What I would like is for a toggle button to show either all rows with "ToggleTrue" or "ToggleFalse". However, I would also like the "Hideme" rows to never be shown whether the toggle button is pressed or unpressed.
Does anybody know how to write code for this? Many thanks for some input!
Hello goomblar,
It will all depend on how your Code is structured within that Workbook. To help us not guessing what your setup looks like could you please, attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
You should have posted a sample spreadsheet.
I had to create my own
Three macros are involved
Two Sheet Specific and One Normal
One macro runs when the sheet is activated to hide the hideme columns
Another handles the checkbox event
and finaly the standard macro hides the rows
Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by mehmetcik; 10-02-2014 at 06:19 AM.
It just occurred to mre that the worksheet activate macro would be more effective if it were modified to:
Please Login or Register to view this content.
Maybe:
Please Login or Register to view this content.
Hi All,
Thank you for your informative responses. For all intents and purposes, mehmetcik's attachment works. However, it is necessary that a toggle button is utilized. As requested, I've attached an example file that will hopefully clear things up a bit. I should point out that it is purely manually explained; There is no code or reference cells in the file.
JOHN H. DAVIS - I just saw your post now so I will take a look at it and get back to you.
EDIT: I should also point out that I need this for a limited range, not an infinite amount of rows. In the attachment, you can see that this range is for S5:S28
Last edited by goomblar; 10-02-2014 at 10:18 AM.
Modified:
Please Login or Register to view this content.
Hi JOHN H. DAVIS,
Thanks for the fast reply; your code works splendidly on my Workbook. However, when a value in column S is changed from, say, ToggleTrue to ToggleFalse, the toggle button no longer works properly.
The reference cells will be updated various times in a day/week, and the toggle parameters need to take that into account. Any thoughts?
How does it not work properly? What happens?
I've tried it again and I had just inputted it incorrectly - It works perfectly fine. Thank you!
If I could request one additional thing... In order to input this into the more complex file that will actually be used, the parameters are as such actually S9:S48.
How would I change the code to make this work? I've tried it myself and it for some reason freezes after running on all rows, not just the specified range. (I admit I am quite poor at VBA...)
Try this version.
I have pared it down a bit
Please Login or Register to view this content.
Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by mehmetcik; 10-03-2014 at 07:19 AM.
mehmetcik,
Your solution has completely solved this issue, and seems to be working fine on my real file.
Just to clarify what issues had persisted with JOHN H. DAVIS' code:
1. When ToggleTrue was the first value, it no longer toggled between the two values. It only showed ToggleTrue.
2. When ToggleFalse was the only value for the whole range, the workbook froze after running endlessly.
I will play around with your code some more and if I encounter anything else I will come back. MANY thanks for everyone's support here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks