Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox centered in cell
I have the following code to add a checkbox in a cell and center it top to
bottom: Set chk = cell.Parent.CheckBoxes.Add(cell.Left, cell.Top, 12, cell.Height) chk as Excel.checkbox cell as Range This code works fine in one procedure, but in another one the checkbox is in the bottom of the cell. Any Ideas what to do to fix this? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox centered in cell
Depending on what the size of the cell is, you could play around with something
like: Dim chk As CheckBox Dim cell As Range Set cell = ActiveSheet.Range("E7") With cell Set chk = .Parent.CheckBoxes.Add(Left:=.Left, _ Top:=.Top + (.Height / 4), _ Width:=.Width, _ Height:=.Height / 4) End With ranswert wrote: I have the following code to add a checkbox in a cell and center it top to bottom: Set chk = cell.Parent.CheckBoxes.Add(cell.Left, cell.Top, 12, cell.Height) chk as Excel.checkbox cell as Range This code works fine in one procedure, but in another one the checkbox is in the bottom of the cell. Any Ideas what to do to fix this? Thanks -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox centered in cell
Thanks
I'll give that a try. Any idea it works in one procedure, but not another? "Dave Peterson" wrote: Depending on what the size of the cell is, you could play around with something like: Dim chk As CheckBox Dim cell As Range Set cell = ActiveSheet.Range("E7") With cell Set chk = .Parent.CheckBoxes.Add(Left:=.Left, _ Top:=.Top + (.Height / 4), _ Width:=.Width, _ Height:=.Height / 4) End With ranswert wrote: I have the following code to add a checkbox in a cell and center it top to bottom: Set chk = cell.Parent.CheckBoxes.Add(cell.Left, cell.Top, 12, cell.Height) chk as Excel.checkbox cell as Range This code works fine in one procedure, but in another one the checkbox is in the bottom of the cell. Any Ideas what to do to fix this? Thanks -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox centered in cell
Maybe 12 is too big.
ranswert wrote: Thanks I'll give that a try. Any idea it works in one procedure, but not another? "Dave Peterson" wrote: Depending on what the size of the cell is, you could play around with something like: Dim chk As CheckBox Dim cell As Range Set cell = ActiveSheet.Range("E7") With cell Set chk = .Parent.CheckBoxes.Add(Left:=.Left, _ Top:=.Top + (.Height / 4), _ Width:=.Width, _ Height:=.Height / 4) End With ranswert wrote: I have the following code to add a checkbox in a cell and center it top to bottom: Set chk = cell.Parent.CheckBoxes.Add(cell.Left, cell.Top, 12, cell.Height) chk as Excel.checkbox cell as Range This code works fine in one procedure, but in another one the checkbox is in the bottom of the cell. Any Ideas what to do to fix this? Thanks -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox centered in cell
Thanks
"Dave Peterson" wrote: Maybe 12 is too big. ranswert wrote: Thanks I'll give that a try. Any idea it works in one procedure, but not another? "Dave Peterson" wrote: Depending on what the size of the cell is, you could play around with something like: Dim chk As CheckBox Dim cell As Range Set cell = ActiveSheet.Range("E7") With cell Set chk = .Parent.CheckBoxes.Add(Left:=.Left, _ Top:=.Top + (.Height / 4), _ Width:=.Width, _ Height:=.Height / 4) End With ranswert wrote: I have the following code to add a checkbox in a cell and center it top to bottom: Set chk = cell.Parent.CheckBoxes.Add(cell.Left, cell.Top, 12, cell.Height) chk as Excel.checkbox cell as Range This code works fine in one procedure, but in another one the checkbox is in the bottom of the cell. Any Ideas what to do to fix this? Thanks -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making the text in a cell with a money format centered | Excel Discussion (Misc queries) | |||
Keep chart centered to the page | Charts and Charting in Excel | |||
Watermark centered in PageLay-out | Excel Programming | |||
Cell alignment centered | Excel Programming | |||
Centered and right justified using ticks | Excel Discussion (Misc queries) |