Macro for adding VBA checkboxes

**steve_l** · 11-23-2011, 05:11 AM

Hi, I don't suppose anyone has a macro that would be capable of inserting VBA checkboxes into cells b3 to b1001 which when ticked/ unticked return the value of yes / no in the adjacent cell in in the C column?

Thanks in advance!

**royUK** · 11-23-2011, 05:40 AM

Try a different way, see my example here

**TMS** · 11-23-2011, 05:50 AM

Maybe:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Regards

**steve_l** · 11-23-2011, 06:18 AM

Thanks for the replies, both methods seem to work but am facing another problem with it!

I want the output of the checkbox eg "true or false" to be used by another piece of VBA code I have in unlocking a cell. eg, if i tick the tick box in Cell B3, it displays "TRUE" in C3and then the VBA code should unlock Cell D3 for editing.

If I manaully type "TRUE" into cell C3 then D3 unlocks fine but if I use the tick boxes to display "TRUE" in C3, D3 will not unlock.

It is as if VBA will not recognise the result of the checkbox as a "TRUE" value?

Very confused!

**TMS** · 11-23-2011, 06:43 AM

You need to manually enter data for a Worksheet Change event to fire. In this case, it's a bit like changing a value and a formula (dependent on it) showing a different value.

I suspect Roy's method will work better for what you want.

Regards