Converting a Check Box

[mr Maz]

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

 

[Joel]

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]

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]

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]

Thanks Joel,

I really appreciate your efforts with this.

Maz

if anyone else can help please do.