Format Control Check Box Question

[Chris Hoek]

Is it possible to link more than one cell in the Cell link field for a Check Box? I know you can select a range of cells, I've done that. But I need to select two non adjacent cells 'Admin Use Only'!$AX$4 and 'Admin Use Only'!$AX$11. I've tried to put both in there separated by a space, no space, a comma (,) and I've tried a semicolon (. None of these have worked. Anybody know if this is possible? Sorry if this has been previously answered. I did search but did not find an answer.

 

[6StringJazzer]

No you cannot.

What problem are you trying to solve? There might a solution with formulas or VBA.

 

[Chris Hoek]

No you cannot.

What problem are you trying to solve? There might a solution with formulas or VBA.

Honestly it isn't really a problem. I considered VBA. I think I'm just going to use a formula. Not a biggie, just really wanted to know if it was possible. Thanks for your expertise!

 

[6StringJazzer]

By "problem" I just meant "what are you trying to do?" If you need more than one cell to show the checkbox state, you can link to one cell, such as AX11, then other cells can

=AX11

But if you need it in reverse, where you want to type a value into multiple cells and have it affect the checkbox state, you need VBA.

 

[Chris Hoek]

=AX11

This is exactly what I ended up doing. Thanks again mate.

 

[6StringJazzer]

Hope I helped if only a little. Cheers!