checkbox challenge

gaming_mouse

Board Regular
Joined
Apr 6, 2005
Messages
139
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
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
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

Board Regular
Joined
Apr 6, 2005
Messages
139
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
 

gaming_mouse

Board Regular
Joined
Apr 6, 2005
Messages
139

ADVERTISEMENT

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.
 

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,091
Messages
5,545,906
Members
410,711
Latest member
Josh324
Top