Hello! Thank you for an awesome video. In my spreadsheet, I have 40 rows of checkboxes with two checkboxes on each row (Yes or No). How can I set checkbox capability to be able to only select one checkbox (yes or no) per each row?
hey, i have a curious problem when i do it this way. As soon as I go to print, I don't see a preview of the document as it looks when printed. This is only the case when an ActiveX checkbox is ticked, do you have an idea?
@@Excel10tutorial hey thank you for the reply. Ive forgot to say that im trying to build this in Microsoft Word. Unlucky there is not the option for that. Do you have an idea for Word?
Hello and congratulations on your work! I wrote the same code and it works. However, when there are other calculations on the sheet, it doesn't work. Can I send you the file sample that i made for review?
Great but I have a problem with the first code. After trying to run it, the following are being highlighted "Public WithEvents Allow1CheckBox As MSForms.CheckBox". Must the entire first code being copied?
the explanation is easy to understand, thank you and greetings from Indonesia 🇮🇩
Thanks a million for the comment. Please subscribe and share.
@@Excel10tutorial you're welcome 👌
Hello! Thank you for an awesome video. In my spreadsheet, I have 40 rows of checkboxes with two checkboxes on each row (Yes or No). How can I set checkbox capability to be able to only select one checkbox (yes or no) per each row?
Adding onto this comment as I have the same request as well!
Did you get at solution for this??
HI there. Thank you for the explaination. It's very useful. Can you share how to count activex checkbox?
Hello, the explanation is really useful. How can I apply it to an entire column in excel?
Thank you for explanation! How can I allow more than one check box?
I cannot access the VBA code using the link you provided. It requires that I since up for a paid annual subscription to view the code.
Nope. Its free for everyone. Please check again.
hey, i have a curious problem when i do it this way. As soon as I go to print, I don't see a preview of the document as it looks when printed. This is only the case when an ActiveX checkbox is ticked, do you have an idea?
Right-click on the checkbox, and select Format Control.
Go to Properties Tab.
Tick mark “Print Object”.
@@Excel10tutorial hey thank you for the reply. Ive forgot to say that im trying to build this in Microsoft Word. Unlucky there is not the option for that. Do you have an idea for Word?
Hello and congratulations on your work! I wrote the same code and it works. However, when there are other calculations on the sheet, it doesn't work. Can I send you the file sample that i made for review?
Send me
Great but I have a problem with the first code. After trying to run it, the following are being highlighted "Public WithEvents Allow1CheckBox As MSForms.CheckBox". Must the entire first code being copied?
Copy the code correctly. Make sure you don't miss any line
Hey there. It doesnt't work form me, i don't know what the problem is... can you help me please?
It should. Try again. Make sure you save the workbook as .xlsm format.
I code cant run, macro dialogue box opens