![]() ![]() Insert multiple checkboxes with Kutools for Excel And then click OK, the checkboxes have been inserted in the range neatly and beautifully. ![]() ![]() ![]() And a prompt box will pop out to remind you to select a range of cells that you want to insert the checkboxes. With Ws.CheckBoxes.Add(Rng.Left, Rng.Top, Rng.Width, Rng.Height)Ģ. Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8) Click Developer > Visual Basic, a new Microsoft Visual Basic for applications window will be displayed, click Insert > Module, and input the following code into the Module: Sub InsertCheckBoxes() If you think the first method is somewhat troublesome, the following VBA code can help you easily and quickly insert multiple checkboxes.ġ. Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |