I have a form I am creating, I need to add several columns of check-boxes which are linked to the their respective cell in the next columns. I have only been able to do one column with some Marco I have already found, but I can not link the remaining with the same Marco. Can anyone help me?
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.
Because browsers behave differently, many of our members cannot see uploaded images. Do not upload a picture of your file as this will only delay getting solutions.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I do not understand what you mean by before and after. I have attached a file, of what I am trying to do(all sensitive data is removed). I have linked the first three rows manually already. How would I be able to the the rest? All the position of the cell arrangement are the same as the original data.
Hi coyotes_wild
This Code in the attached will handle Columns I, J and N. Add the rest. Run the Sub addCBX()...let me know.
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Thank you so much! It works perfectly!!
You're welcome...glad I could help. Thanks for the Rep.
The Delete Code should be this...sorry, copied it from my Tool Box and forgot to change it.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks