me, possibly others but not likely).This article is written like a manual or guidebook. Just trying to make this as easy and brain-dead as possible for the end-user (i.e. I hate using the mouse, but in this case clicking on something like a checkbox seems easier than ctrl-c / ctrl-v and then go back and possibly have to go back and manually delete the source checkbox or something. I'll freely admit that I could just put an "X" in a cell and be done with it but I guess I preferred "form" over "function" in this case which isn't always the best idea, heh. When I go to duplicate the rows, will the code duplicate itself as well? I'm thinking maybe not but this VBA functionality is definitely new to me.Ĭombo, I'll check out the old wingdings checkmark. I wasn't aware that you could have programming on a specific cell like that. I'll say I like the functionality of the checkbox, click on/off and if I want to change the selection it's just as easy. RE: Checkboxes in Excel - ActiveX-based vs Form-based SkipVought (Programmer) 24 Nov 20 19:19 Is it possible to create a template of a form and then cut/paste it into Excel using Form-based checkboxes? Is there a way to search/replace ActiveX checkboxes vs Form checkboxes?Ģ. I've attached the excel template for your viewing pleasure.ġ. The original PDF was not created as a form which is why I did this. They're just a checkbox to indicate "yes" or "no" for the reader. I need to be able to cut and paste to add more entries as I add information to the spreadsheet. ActiveX controls seem to cut and paste more easily. I'm not sure why I chose ActiveX controls to be honest, but after messing with the form controls I think it's because I'm not able to cut and paste a Form-based checkbox and have it end up in the "right place". Unfortunately, after using this form that I recreated, there's a few hundred of these checkboxes and the spreadsheet has become nearly unusable due to the resources required on my part. Part of the form uses checkboxes, so I added checkboxes accordingly using the Developer tab and picking from Form or ActiveX controls. I recreated a PDF form in Excel (Office 365) to make it easier for me to enter data, duplicate rows, etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |