Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning checkbox to the cell
I am writing a macro for a button. When I push the button, it should insert a
new row with 10 cells in a table and assign checkboxes to the last 5 cells of the row. In a macro how do I assign checkboxes to the cells of the new row ? Is it possible ? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning checkbox to the cell
Which checkboxes are you using. Control Toolbox Toolbar or forms Toolbar.
You say 10 cells in a table - what does that mean. Do you mean 1 row 10 cells wide? 10 full rows. 10 rows the width of the table. How is the table defined. Where in the table do you want the 10 rows. Where would the checkboxes be located relative to the 10 cells. What cells would they be linked to? -- Regards, Tom Ogilvy "fbagirov" wrote: I am writing a macro for a button. When I push the button, it should insert a new row with 10 cells in a table and assign checkboxes to the last 5 cells of the row. In a macro how do I assign checkboxes to the cells of the new row ? Is it possible ? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning checkbox to the cell
A table has 10 columns. 1 row is 10 cells wide. 5 checkboxes are in the last
5 cells of each row, one checkbox per cell. Sorry for not making it clear. "Tom Ogilvy" wrote: Which checkboxes are you using. Control Toolbox Toolbar or forms Toolbar. You say 10 cells in a table - what does that mean. Do you mean 1 row 10 cells wide? 10 full rows. 10 rows the width of the table. How is the table defined. Where in the table do you want the 10 rows. Where would the checkboxes be located relative to the 10 cells. What cells would they be linked to? -- Regards, Tom Ogilvy "fbagirov" wrote: I am writing a macro for a button. When I push the button, it should insert a new row with 10 cells in a table and assign checkboxes to the last 5 cells of the row. In a macro how do I assign checkboxes to the cells of the new row ? Is it possible ? Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning checkbox to the cell
Assuming you want the row inserted above the activeCell, extending to the
right. .. Sub AddRow() Dim rng As Range, cell As Range Dim cbox As CheckBox, i As Long Set rng = ActiveCell.Resize(1, 10) rng.Interior.ColorIndex = 3 rng.Insert Shift:=xlDown Set rng = rng.Offset(-1, 0) For i = 6 To 10 Set cell = rng(1, i) Set cbox = ActiveSheet.CheckBoxes.Add( _ Left:=cell.Left, _ Top:=cell.Top, _ Width:=cell.Width, _ Height:=cell.Height) cbox.LinkedCell = cell.Address(1, 1, xlA1, True) Next i End Sub -- Regards, Tom Ogilvy "fbagirov" wrote in message ... A table has 10 columns. 1 row is 10 cells wide. 5 checkboxes are in the last 5 cells of each row, one checkbox per cell. Sorry for not making it clear. "Tom Ogilvy" wrote: Which checkboxes are you using. Control Toolbox Toolbar or forms Toolbar. You say 10 cells in a table - what does that mean. Do you mean 1 row 10 cells wide? 10 full rows. 10 rows the width of the table. How is the table defined. Where in the table do you want the 10 rows. Where would the checkboxes be located relative to the 10 cells. What cells would they be linked to? -- Regards, Tom Ogilvy "fbagirov" wrote: I am writing a macro for a button. When I push the button, it should insert a new row with 10 cells in a table and assign checkboxes to the last 5 cells of the row. In a macro how do I assign checkboxes to the cells of the new row ? Is it possible ? Thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning checkbox to the cell
Thanks!
The only problem is that the checkboxes show their property names (CheckBox1, Checkbox2, etc) and when you click on them they show the value (TRUE or FALSE) in the cell. How do I turn that off ? Also, if the active cell is not in the first column, the code inserts the row in whatever cell is active. how do I make it insert from the first column of the row ? Thanks! "Tom Ogilvy" wrote: Assuming you want the row inserted above the activeCell, extending to the right. .. Sub AddRow() Dim rng As Range, cell As Range Dim cbox As CheckBox, i As Long Set rng = ActiveCell.Resize(1, 10) rng.Interior.ColorIndex = 3 rng.Insert Shift:=xlDown Set rng = rng.Offset(-1, 0) For i = 6 To 10 Set cell = rng(1, i) Set cbox = ActiveSheet.CheckBoxes.Add( _ Left:=cell.Left, _ Top:=cell.Top, _ Width:=cell.Width, _ Height:=cell.Height) cbox.LinkedCell = cell.Address(1, 1, xlA1, True) Next i End Sub -- Regards, Tom Ogilvy "fbagirov" wrote in message ... A table has 10 columns. 1 row is 10 cells wide. 5 checkboxes are in the last 5 cells of each row, one checkbox per cell. Sorry for not making it clear. "Tom Ogilvy" wrote: Which checkboxes are you using. Control Toolbox Toolbar or forms Toolbar. You say 10 cells in a table - what does that mean. Do you mean 1 row 10 cells wide? 10 full rows. 10 rows the width of the table. How is the table defined. Where in the table do you want the 10 rows. Where would the checkboxes be located relative to the 10 cells. What cells would they be linked to? -- Regards, Tom Ogilvy "fbagirov" wrote: I am writing a macro for a button. When I push the button, it should insert a new row with 10 cells in a table and assign checkboxes to the last 5 cells of the row. In a macro how do I assign checkboxes to the cells of the new row ? Is it possible ? Thanks |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning checkbox to the cell
Sub AddRow()
Dim rng As Range, cell As Range Dim cbox As CheckBox, i As Long Set rng = Cells(ActiveCell.row,1).Resize(1, 10) rng.Interior.ColorIndex = 3 rng.Insert Shift:=xlDown Set rng = rng.Offset(-1, 0) For i = 6 To 10 Set cell = rng(1, i) Set cbox = ActiveSheet.CheckBoxes.Add( _ Left:=cell.Left, _ Top:=cell.Top, _ Width:=cell.Width, _ Height:=cell.Height) cbox.LinkedCell = cell.Address(1, 1, xlA1, True) Next i End Sub -- regards, Tom Ogilvy "fbagirov" wrote in message ... Thanks! The only problem is that the checkboxes show their property names (CheckBox1, Checkbox2, etc) and when you click on them they show the value (TRUE or FALSE) in the cell. How do I turn that off ? Also, if the active cell is not in the first column, the code inserts the row in whatever cell is active. how do I make it insert from the first column of the row ? Thanks! "Tom Ogilvy" wrote: Assuming you want the row inserted above the activeCell, extending to the right. .. Sub AddRow() Dim rng As Range, cell As Range Dim cbox As CheckBox, i As Long Set rng = ActiveCell.Resize(1, 10) rng.Interior.ColorIndex = 3 rng.Insert Shift:=xlDown Set rng = rng.Offset(-1, 0) For i = 6 To 10 Set cell = rng(1, i) Set cbox = ActiveSheet.CheckBoxes.Add( _ Left:=cell.Left, _ Top:=cell.Top, _ Width:=cell.Width, _ Height:=cell.Height) cbox.LinkedCell = cell.Address(1, 1, xlA1, True) Next i End Sub -- Regards, Tom Ogilvy "fbagirov" wrote in message ... A table has 10 columns. 1 row is 10 cells wide. 5 checkboxes are in the last 5 cells of each row, one checkbox per cell. Sorry for not making it clear. "Tom Ogilvy" wrote: Which checkboxes are you using. Control Toolbox Toolbar or forms Toolbar. You say 10 cells in a table - what does that mean. Do you mean 1 row 10 cells wide? 10 full rows. 10 rows the width of the table. How is the table defined. Where in the table do you want the 10 rows. Where would the checkboxes be located relative to the 10 cells. What cells would they be linked to? -- Regards, Tom Ogilvy "fbagirov" wrote: I am writing a macro for a button. When I push the button, it should insert a new row with 10 cells in a table and assign checkboxes to the last 5 cells of the row. In a macro how do I assign checkboxes to the cells of the new row ? Is it possible ? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning Macros to Run from a Cell | Excel Discussion (Misc queries) | |||
assigning a value to a cell | Excel Worksheet Functions | |||
using match in vba without assigning a cell | Excel Programming | |||
Assigning a value to an array cell | Excel Programming | |||
Assigning click event to OleObjects checkbox | Excel Programming |