Check Box Items Displayed On A Differnt Sheet

strams

New Member
Joined
Oct 5, 2006
Messages
1
Hello Everyone,

Hopefully this is a simple question that my lack of Excel knowledge is stumping me on and one of you might know...

I have a series of checkboxes, we'll say checkbox 1-5. These are all listed on a sheet called products.

If for example you select check boxes 1,3 and 5 I need those to then be listed in a column in that order on another sheet called purchased.

If I went back and then uncheck 3 and check 4 then purchased would be updated.

I understand that if you take a cell and name it P1 for instance..and then on another sheet enter =p1 in a cell that they will update and share data, but I dont know how to pull from a check box..nor do I know how to assign a row of cells to accept multiple and changing information from those checkboxes.

Hopefull i explained that well enough. Any help would be appreciated...thanks in advance.
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Ron Morris

Active Member
Joined
Oct 18, 2004
Messages
430
I am assuming you are using a checkbox from the forms toolbar.

You can always create a column to hold the selection of the check box since check boxes always return either TRUE or FALSE.

Right click on the Checkbox and then click on "Format References"

At cell link, enter the cell you want the result of the checkbox to appear.
Repeat this step for all your checkboxes.

Hide the column.

On your purchased page, write a formula referring to the TRUE OR FALSE CELL, I am using A1 for the sake of an example.

=IF(A1=TRUE,"Apple","")

This would create your list but leave blank spaces whenever something isn't purchased.

Ron
 

Forum statistics

Threads
1,141,143
Messages
5,704,537
Members
421,353
Latest member
jekoxien15

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