Use of checkboxes

[Mark Stephens]

Hi,

I have a very simple task and I was hoping someone can help me find out how
I do it...I have a few rows of data in worksheet1 and have positioned a
checkbox to the left of each row.

I want to check each box for the row I want to select and then when I click
a button on the page (to say I'm finished selecting) have the code check
each to see if it is selected and if so do whatever with the selected rows.

Apologies for asking what must be a very simple question but unlike Excel
20003 the new (wonderful) version 2007 wil not record anything to do with
autoshapes (including checkboxes) so I can't use my usual way of finding
out.

Thanks in advance, regards, Mark

 

[Joel]

Checkboxes have a property LinkedCell. The Linked cell will display True or
false depending if the box is checked or Not checked. You can make the
linked cell a hiden column or another worksheet so it is not seen.

 

[Mark Stephens]

Hi Joel,

Appreciate the heads up, I am coming back to excel after a long absence so
it is heartening to see the user group is still very helpful, works well