Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Check Boxes
How do I fill a column of 50 rows with check boxes ? Fill Down doesn't seem to do it.. Best Wishes Bruce ( Illegitimi non carborundum est ) |
#2
|
|||
|
|||
Maybe you could just use a macro to populate the range you want.
Option Explicit Sub addCBX() Dim myCBX As CheckBox Dim myCell As Range With ActiveSheet .CheckBoxes.Delete 'nice for testing For Each myCell In .Range("a1:a50").Cells With myCell Set myCBX = .Parent.CheckBoxes.Add _ (Top:=.Top, Width:=.Width, _ Left:=.Left, Height:=.Height) With myCBX .LinkedCell = myCell.Address(external:=True) .Caption = "" 'or whatever you want .Name = "CBX_" & myCell.Address(0, 0) End With .NumberFormat = ";;;" End With Next myCell End With End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Bruce wrote: How do I fill a column of 50 rows with check boxes ? Fill Down doesn't seem to do it.. Best Wishes Bruce ( Illegitimi non carborundum est ) -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check boxes - when one box is checked, I want a 2nd box to auto ch | Excel Discussion (Misc queries) | |||
Check Boxes | Excel Discussion (Misc queries) | |||
Check Boxes | Excel Worksheet Functions | |||
count check boxes | Excel Worksheet Functions | |||
Protection of check boxes in excel 2002 | Excel Discussion (Misc queries) |