Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
check boxes
I have the following code that adds a checkbox to my worksheet:
Sub addcheckbox() Dim a As String Dim costid As String Dim cboxname As Integer Dim cell As Range Dim chk As Excel.CheckBox Set cell = ActiveCell Set chk = cell.Parent.CheckBoxes.Add(cell.Left, cell.Top, 12, cell.Height) costid = id MsgBox ("costid =" & costid) chk.Height = cell.Height - 1.5 cboxname = ActiveCell.EntireRow.Cells(13) chk.Characters.Text = none chk.name = "Checkbox" & costid & cboxname chk.LinkedCell = ActiveCell.EntireRow.Cells(14).Address ActiveCell.Select End Sub When I go to hide the range that contains the check box, the check box isn't hidden. Is the a property that I need to set to hide the check box? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
all the check boxes should be checked if i check a particular checkbox in that row | Excel Programming | |||
How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) |