Hi,
I have many checkboxes in column A from A6 onwards which i have checked on to generate some specific reports.Now ,I want to get them uncheck all as one by one it is time consuming.
Kindly guide me through this.
Hi,
I have many checkboxes in column A from A6 onwards which i have checked on to generate some specific reports.Now ,I want to get them uncheck all as one by one it is time consuming.
Kindly guide me through this.
Perhaps...
Or for Active XPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by sintek; 05-04-2019 at 05:35 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
The first one works but I want to uncheck from A6 and below rows checkboxes only and not of whole worksheet
Please Login or Register to view this content.
Last edited by sintek; 05-04-2019 at 05:52 AM.
It worked but it is very very slow when I use having checkboxes more than 500.How the code can be restated for faster unchecking.
Upload sample file to test...Sure someone will come up with a solution if this does not work...
Add...start of code...after Dim i As Long
End of code before End subPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by sintek; 05-04-2019 at 01:21 PM.
Pls find enclosed in attachment.There might be more.I want uncheck to be faster.For whole worksheet your first code was awesome faster but for specific column which is A from A6 and below the code provided is not faster.
I have remove other columns data & row as I want to focus on uncheck part only.
I now hope you will revised it accordingly.
See if this option works a little quicker:
Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Nice one Arkadi...Only 1 loop...
Thanks @sintek I assumed the double loop was the issue since the first code looked at all checkboxes but ran quickly enough.
Credit goes mostly to you... I just tweaked it a bit.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks