Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checkbox question
can you "lock" a checkbox to its linked cell in regards to height, width,
and position? In other words once placed, the checkbox would cover the cell, and if the size or position of the cell is changed the size/position of the box would alter with it. if so: what is the setting? how would this need to be noted in VBA? For Each rCell In rng With SH.CheckBoxes.Add(rCell.Left + 4, _ rCell.Top - 2, 0, 0) .Caption = "" .LinkedCell = rCell.Address(0, 0) End With |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot select checkbox to delete it from a spreadsheet | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
copy many CHECKBOX | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |