Tick/Check Boxes

Silvermini63

Active Member
Joined
Sep 25, 2006
Messages
293
If I have 2 different tick boxes on for contract and one for quote on one worksheet when they are marked how could I get this to show either quote or contract on another worksheet within the work book.

Hope this makes sense
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,453
Hello Silvermini63,
There are a number of ways. Which one(s) work for you depends on what you're using and
(to some extent) your preference.
If you're using checkboxes from the Forms toolbar, you can assign them a linked cell.
(Right click the checkbox, choose Format control > Control tab > Cell link field.)
Enter any cell you like (out of site if you want.)

(Say the checkbox is on sheet1 & the cell link is A1.)
On sheet2, in whatever cell you choose, enter the formula:
=IF(Sheet1!A1 =TRUE,"Quote","")

Do the same for the Contract checkbox.

If you're using something different then post back with more details on what you've got
and what you want to do.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,849
Messages
5,544,645
Members
410,627
Latest member
georgealice
Top