Check box value based on Cell value

[raghunandandas]

I have two questions :

1) Can one check box be associated with one cell..?

2) I have a field/column in excel sheet with text. It may contain any text, number, space or no value in this field/column

I used =ISNUMBER((SEARCH("NULL",C5,1)))

C5 is the cell having text
D5 has the above formula

Now D5 has value True or False.

What I need is to check whether the text in that column has NULL in it. If it has NULL then the associated check box in the next column should be checked ... if not it should remain unchecked...

Can any one help me on this

 

[Mala]

View...Toolbar...select forms toolbar
From the toolbar draw a check box on your worksheet
right click check box to select if
From the shortcut menu select Format control
In the dialog box go to the 'Control' tab and in cell link, point to D5
Click OK
If doing this erases the formula in D5 and puts in FALSE, just re-enter the formula =ISNUMBER((SEARCH("NULL",C5,1)))
BUT...clicking the checkbox hereafter is a big no...no - doing so will overwrite the formula with the next toggle value of the checkbox
To prevent this from happening, you need to format the chkbox as locked (it is the default) and protrct the worksheet

 

[raghunandandas]

Thank you very much for the quick response and .....


Now I have data in C5 ... formula in D5 and the check box is linked with D5 and its working fine as per my requirement......

I have so many records and I want as many check boxes as records... Is there any way I can easily do... or I have to create all the check boxes and keep changing the properties.....

..Raghu