Hi All,

I have a lot of data with check boxes used to show a yes or no answer.

I wish to convert these into simple Yes/No answers (maybe converting to a
list box) automatically.

Is there anyway of doing this?

I have tried importing the tables into Access but the fields with the check
boxes appear blank.

Please help

Check boxes have a property LinkedCell which will put a True or False in the
indicated cell. A check box is a shape which sits on top of the worksheet
and is NOT associated with any cell.

"mr Maz" wrote:

Hi All,

I have a lot of data with check boxes used to show a yes or no answer.

I wish to convert these into simple Yes/No answers (maybe converting to a
list box) automatically.

Is there anyway of doing this?

I have tried importing the tables into Access but the fields with the check
boxes appear blank.

Please help

Ahh... Thanks Joel,

Ok I've managed to do that on one box at a time.

is there a way of doing this to the entire worksheet at the same time?

Your help is much appreciated.

Maz

"Joel" wrote:

Check boxes have a property LinkedCell which will put a True or False in the
indicated cell. A check box is a shape which sits on top of the worksheet
and is NOT associated with any cell.

"mr Maz" wrote:

Hi All,

I have a lot of data with check boxes used to show a yes or no answer.

I wish to convert these into simple Yes/No answers (maybe converting to a
list box) automatically.

Is there anyway of doing this?

I have tried importing the tables into Access but the fields with the check
boxes appear blank.

Please help

It is possible to do it with a macro. What you need to know is how to
identify each box to each cell. I'm having trouble getting the right format
of the macro commands.

"mr Maz" wrote:

Ahh... Thanks Joel,

Ok I've managed to do that on one box at a time.

is there a way of doing this to the entire worksheet at the same time?

Your help is much appreciated.

Maz

"Joel" wrote:

Check boxes have a property LinkedCell which will put a True or False in the
indicated cell. A check box is a shape which sits on top of the worksheet
and is NOT associated with any cell.

"mr Maz" wrote:

Hi All,

I have a lot of data with check boxes used to show a yes or no answer.

I wish to convert these into simple Yes/No answers (maybe converting to a
list box) automatically.

Is there anyway of doing this?

I have tried importing the tables into Access but the fields with the check
boxes appear blank.

Please help

Thanks Joel,

I really appreciate your efforts with this.

Maz

if anyone else can help please do.