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

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
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
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,237
Members
448,555
Latest member
RobertJones1986

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
Back
Top