Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to have a column in my spreadsheet that contains a
check box. I need to dynamically create this once the spreadsheet is populated from the database. I am doing this by copying a dummy one I have on a hidden sheet with the following code: Sub CreateCheckBoxes() NumRows = Range("B4").CurrentRegion.Rows.Count + 4 For x = 5 To NumRows Sheets("Input Data").Shapes("chkView").Copy Range("J" & x).Select ActiveSheet.Paste Selection.Name = "chkView" & Range("A" & x).Value Next x End Sub I want the check box to be in each row of the J column. But, it doesn't place it here. Anyone know how to force the check box to do into a particular cell without hard-coding the position coordinates? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
Creating checkable boxes w/o the check box forms tool | Excel Worksheet Functions | |||
Creating fillalbe check boxes in excel by double clicking on chec. | Excel Discussion (Misc queries) | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
Creating Formula using check boxes | Excel Discussion (Misc queries) |