Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Checkbox basics

Status
Not open for further replies.

monagan

Technical User
May 28, 2004
138
US
I have 7 checkboxes

What I need to do is if checkbox1(a15) is unchecked I want the values in c15:i15 to be 0.

if it is checked, I want the values to be whatever the formulas in the cells come out to be.

A quick suggestion or point to a thread I haven't looked at would probably be good enough

Thanks in advance
 
I finally figured this one out.
What I ended up doing is:

Going to format control, and linked the cell it was on(a1) to the check box under control

Then put =if(a1,"Original Formula",0) in my formula cells

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top