checkbox challenge

[gaming_mouse]

Hi,

In every row, there is a name in column A, and checkbox in column B. The name is column A should be highlighted if the checkbox is checked.

I'm working with someone else workbook here, so I know little about checkboxes, or how to refer them.

Thanks for any help,
gm

 

[SteveO59L]

Use the Linked cell property of the check box to set a cell to true/false.

Use conditional formatting based on the true/false cell

 

[gaming_mouse]

Hey Steve,

Can I get some more info from you?

How exactly would I do this? How do you access the LinkedCell property? I don't even know how to access the checkbox itself, or how to find the checkbox's name. As I said, completely new to checkboxes.

Thanks for any additional help,
Jonah

 

[SteveO59L]

How did you create the checkboxes ?

 

[gaming_mouse]

How did you create the checkboxes ?

That's the problem. I didn't. It's a worksheet created by someone else. If you need to know some info about them to answer the question, just let me know what I need to do to find the info.

Thanks.

 

[gaming_mouse]

can anyone else help out here?

 

[SteveO59L]

Checkboxes can be created by either the Forms toolset or the Controls toolset. And the methods of working with them differ according to how they were created.

Try selecting the checkbox and right-clicking on it.

If the 4th item on the menu is "Properties", then it is from the Contols toolset, select this option and the properties dialog box is launched. About halfway down is the "Linked Cell" property.

For a Forms checkbox, rightclick and select the "Format Control" option, there should be a tab for "Control" on which you will find a "Cell Link" entry.