Excel CheckBox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Angela - 27 Jul 2007 21:04 GMT

I've created a checkbox in A1.
If the checkbox is checked, I want B1 to appear as 1 and if not, 2. I
cannot get my if function to work. The worksheet recongnizes A1 as an empty
cell. I tried checkbox1>"1", and got a name error message. Help.

Reply to this Message

Peo Sjoblom - 27 Jul 2007 21:53 GMT

You need to link the check box to a cell and it will return either TRUE or
FALSE so if it is linked to H1 you can use this in B1

=IF(H1,1,2)

You could link it to a cell that is not visible (like IV1) or hide the
column where the linked cell is
if you don't like to see TRUE or FALSE

Signature

Regards,

Peo Sjoblom

> I've created a checkbox in A1.
> If the checkbox is checked, I want B1 to appear as 1 and if not, 2. I
> cannot get my if function to work. The worksheet recongnizes A1 as an
> empty
> cell. I tried checkbox1>"1", and got a name error message. Help.

Reply to this Message

Angela - 27 Jul 2007 22:06 GMT

Great answer, it works. Thanks much

> I've created a checkbox in A1.
> If the checkbox is checked, I want B1 to appear as 1 and if not, 2. I
> cannot get my if function to work. The worksheet recongnizes A1 as an empty
> cell. I tried checkbox1>"1", and got a name error message. Help.

Reply to this Message

Rate this thread: