If you want just the box, leave it blank. If you run the insertCheckboxes macro, you will get the following dialogue:Įnter the range you want checkboxes in (for instance, A1:A10)Įnter the column you want the checkboxes to be linked to (if you select B, that means column B will show the TRUE/ FALSE result of the checkbox).Įnter the label you want on the checkboxes. Return to your workbook and hit Alt-F8 to run a macro.

If there is no module in your current workbook, rightclick the workbook name and use Insert -> New Module to add one. Hit Alt+F11 to open the VBA editor, select the module of your current workbook, and paste that code in. Name = 'checkbox_' & m圜ell.Address(0, 0) Width:=.Width, Left:=.Left, Height:=.Height) LinkedColumn = InputBox(Prompt:='Linked Column', _ĬboxLabel = InputBox(Prompt:='Checkbox Label', _įor Each m圜ell In. Here is one such example code: Option ExplicitĬellRange = InputBox(Prompt:='Cell Range', _ Thankfully people smarter than I have already done that. In order to add a bunch at once, you have to create a VBA function to do it for you. If you copy a single checkbox, it will have all the same properties (including linked cell) meaning you will have to edit it manually each time. There is no built-in way in Excel to generate a load of Form Checkboxes linked to underlying cells.

Insert combo box excel 2010