If you are going to put a checkbox in each cell in column B, then you would be better off using data validation instead of the checkbox due to performance issues. Below is the explanation of how to do this?
To put a dropdown list in cells, users can then select, in your case "Yes or No" from a dropdown and not type the text. Use "Data Validation" select list and enter Yes,No. Auto filter by yes when your work is done. To use Control checkbox select View-ToolBars select Control, than drag a checkBox to your location on the screen. Do the same for the forms toolBar, not you will need to write code to do or put information once the box is checked. The user form check box is done from the Visual Basic editor but works much the same way. On Wed, Jun 3, 2009 at 4:31 PM, busboy10 <andrew.var...@gmail.com> wrote: > > Hi All, > > Is there anyway to have checkboxes in a cell and then be able to > autofilter based on which cells have been checked? > > Ex. Creating a task list in column A and put checkboxes in column B, > when tasks are completed they are checked off. Want to see what tasks > are left so I would like to autofilter the checkboxes to see which > ones are left unchecked. > > I know i can simply put code for EACH checkbox to add a value to the > cell and then filter that but i wanted to avoid any vba. > > any thoughts? > thanks! > > > > -- http://funwithexcel.blogspot.com/ --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
