R
Richard Sherratt
I am trying to create a macro that opens a popup form.
The popup form has a series of check boxes (10-15).
When the popup form closes (or maybe when the user clicks an "OK"
button), I want to the macro to select a cell on the current row and a
defined column and for every check box that's selected, insert some
text in the cells starting with the selected cell and, in the same
column, on the rows below, advancing one row for each additional
selected check box. Does that make sense?
E.g. Say the cursor is in A25 and four check boxes were ticked (item
1, item 7, item 8 and item 13). The defined column is J.
On closing the popup form Cell J25 would contain Item1, J26: Item 7,
J27: item 8 and J28: item 13.
Any ideas?
Regards,
Richard.
The popup form has a series of check boxes (10-15).
When the popup form closes (or maybe when the user clicks an "OK"
button), I want to the macro to select a cell on the current row and a
defined column and for every check box that's selected, insert some
text in the cells starting with the selected cell and, in the same
column, on the rows below, advancing one row for each additional
selected check box. Does that make sense?
E.g. Say the cursor is in A25 and four check boxes were ticked (item
1, item 7, item 8 and item 13). The defined column is J.
On closing the popup form Cell J25 would contain Item1, J26: Item 7,
J27: item 8 and J28: item 13.
Any ideas?
Regards,
Richard.