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
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,454
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.
 

Forum statistics

Threads
1,141,011
Messages
5,703,726
Members
421,311
Latest member
tanujath

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top