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.
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,053
Messages
5,526,502
Members
409,704
Latest member
saialkesh

This Week's Hot Topics

Top