button to check if checkboxes have been checked

[hchiutx]

Hi,

I know how to create checkboxes and buttons, etc. I am okay with VB bu
never tried Excel VBA. I want to create a column full of checkboxe
with no code. At the bottom of sheet1, I want a button that onc
clicked, will check column 1 to see which checkboxes have been checke
then take the corresponding value in column 2 and 3 and copy them t
another sheet. Can this be done? Thanks for your help. This is lik
creating a sub-list from a master.

- Howar

 

[Mark Graesser]

Howard
You will need to link the check boxes to cells. Then if a box isn't checked the linked cell will contain False, if the box is checked it will be True. Then your VB can use the linked cells as the criteria for moving data

Good Luck
Mark Graesse
(e-mail address removed)

----- hchiutx > wrote: ----

Hi

I know how to create checkboxes and buttons, etc. I am okay with VB bu
never tried Excel VBA. I want to create a column full of checkboxe
with no code. At the bottom of sheet1, I want a button that onc
clicked, will check column 1 to see which checkboxes have been checke
then take the corresponding value in column 2 and 3 and copy them t
another sheet. Can this be done? Thanks for your help. This is lik
creating a sub-list from a master

- Howar