![]() The second Input Box (shown below) will set the default value. In the screenshot below, it will create 30 checkboxes, being one in each cell from A1 – C10. ![]() When the VBA code below is run it will display two Input Boxes.įrom the first Input Box select the range of cells in which to create the checkboxes, then click OK. When the macro runs it will create, link, unlock and align as many checkboxes as I need in seconds! That makes me happy □ How the VBA code works So I created some VBA to use in my Personal Macro Book. If I have to create more than 2, then I’m groaning inside because of the inefficient process to set-up each box individually. Each checkbox can be linked to a cell, so that when clicked the value in the cell changes between TRUE and FALSE.īut if you have a lot of checkboxes to create it becomes a real pain there are just too many settings to set for each checkbox. Checkboxes placed onto the face of the worksheet are an excellent way for users to interact with a spreadsheet.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |