LinkBack URL
About LinkBacks
I am creating a document where I want to check or uncheck all checkboxes in just one row with master button.
Can somebody help me please :/
I am creating a document where I want to check or uncheck all checkboxes in just one row with master button.
Can somebody help me please :/
Last edited by 2mi3; 03-11-2015 at 08:29 PM.
If you can tell us which boxes, and provide a file to work with, yes we probably can.
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.
Thanks for a fast response. Can you please tell me how to add a file?
kartica osebe.jpg
I want that long buttons ftom C8 to C20 check and uncheck entire row
When doing a reply, there is a "Go Advanced" button below on the right. Click on that, and then choose the paperclip picture next to the smiley face in the menu above.
Re: check and uncheck certain checkboxes with a button
Thanks for this
Hmmm I'm not getting your attachment (excel file I hope?)
Your picture from before does not get displayed either, so I still don't know exactly what you need.
Hello 2mi3,
Perharps something like the attached sample Workbook, which takes care of either Forms Control Checkboxes, or Active X Control Checkboxes.
Hope that helps.
It is always better to attach a sample Workbook when needed, to illustrate your exact requirement, to enable us to solve your issue to your sastisfaction.
Regards.
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] .
Sorry guys I am such a clumsy.. Here is the excel file. Thanks again
Try this one... It relies on the fact that all your checkboxes are already linked to a cell which was great, and all the boxes in a row are linked to the same cell row. For example all your row 8 boxes are linked to a cell in row 31, so using the row number of the linked cell is how the macros know which boxes to check. Please remember that in future if you add boxes.
Arkadi that is great. Macro is working beautifully
I am grateful for your time and help. However, I have one more problem, How can I mark a column as Sunday or holiday in first sheet (master sheet) and let all the following sheets follow that. Saturday, Sunday and holiday should be also recognized as different by the SUM or COUNTIF formula? I uploaded a file also..
Thanks again
2mi3,
I am sorry I don't understand. Where are you marking something as sunday or holiday in master sheet? and where on other sheets is this supposed to be followed? I also don't know where your formula is, or what you mean by recognized as different... different from what? Once I understand, I'll be more than happy to try and help.
Hello Arkadi, the document is monthly calendar its purpose is to calculate presence and absence to community work and also lunch subvention etc. Since this document will be used by a person who is not very familiar with excel I would like the document to be as automatized as possible. Therefore I created a master sheet - the first sheet of the document, this sheet will be write protected, except saturday, sunday and holiday input (wich I dont know how it will look yet).
Second sheet is sheet of the unit with ten volunteers. There are seven units. This sheet will be fully write protected.
All the other sheets are personal volunteer card where you determinate eather person was absent or where and when it was present. This sheet will be only partial protected - (checkboxes are of course unprotected.)
I am sorry for my poor english and thanks for helping me out again
ps
Since this will be universal document without monday, tuesday and so on already marked I would like to be able to point first sunday with macro button and all the other sundays in the month will be determined by this first one.. folowed by all the other sheets in the document.
OK so sheet abc123, you need a button, it will ask you what first Sunday is, and determine other sundays... but how will it be marked? highlight column for that date, or an x at top... need to know what you want there. Then on ALL other sheets it will mark sundays also.. is that correct?
I see you have columns with dates 1, 8, 15, 22, 29 highlighted right now... is that the way to show sundays?.
Yes, columns 1, 8, 15, 22 and 29 are more or less how Sundays should look. Saturdays are not yet marked neither any holiday. It would be also appropriate to be able to block 31st, 30th and 29th in a month. I donīt have a solution for that either.
Thanks for taking your time to help me out.
Last edited by 2mi3; 03-12-2015 at 02:51 PM.
No problem... I'm pretty busy today, but will try to look at this more tonight at home, or tomorrow morning if I have some time.
Thanks. I appreciate.
Hi 2mi3,
I have most of the Sunday code figured out, I am not certain why the sheets that have a numeric name (1,2,3) think the last row is 30 when it is less... I don't know if your real workbook will have the same problem, but if it does we can make some small adjustments later. For now, please test the code below to see if you are happy with what it does... I would copy all this code and put it in a new module. Then test it, but of course always keep a backup of original before running macros in test mode.
Please Login or Register to view this content.
Last edited by Arkadi; 03-13-2015 at 01:26 PM.
Hi Arkadi,
I copied the code into new module as you suggested and then tried to run it through macros button on the ribbon. First new window appeared which asked for a month setup (I input 3) after second window appeared asking for a year to set up and I entered 2015. This is what I get:
Run-time error '9':
Subscript out of range
Set ws = Worksheets("1") this part was marked yellow as I click debug
Doh sorry did that for testing and forgot to change it back...I will edit my post from before, so just copy it again. SORRY
Code fixed now.
Can this orange color and shape be adjusted on easy way? And can the saturday be atached and determined by the same input?
Last edited by 2mi3; 03-13-2015 at 02:17 PM.
Shape? I don't know what you mean by shape, but the color can change easily... the line:
sets the color, 40 is the orange color you had in your example. If you google "vba colorindex" it will be easy to find information on what number = what color.Please Login or Register to view this content.
Saturday can be added.
In my code this line:
uses the function "datesfordayofweek" to get the dates for sunday which in VBA is default first day of the week. The mnt is the month you entered, yr is the year, and the 1 is sunday. So if you add a second variable, you could also collect dates for saturdays. after thedates=... you could add the same line a second time, maybe call it thedates2?:Please Login or Register to view this content.
see I changed the 1 to a 7? that will do saturdays. Then after this line:Please Login or Register to view this content.
add this line:Please Login or Register to view this content.
to do saturdays also.Please Login or Register to view this content.
Arkadi, thanks a lot you're the best
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks