checkbox in dropdown question

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

I am trying to make a dropdown that will work similar to auto filter except
using checkboxes so I can pick several dates and only see the ones that I
want to. I know this should be easy but I just can not find out how? Any
help would be greatly appreciated.
 
Hi,

The easiest way is to upgrade to 2007, the AutoFilter has this checkbox
feature built in. In 2003 I would suggest looking at the Advanced Filter
command, in that case you set up a criteria range the would look something
like:

Dept
Acct
Admin
Sales

where Dept is one of the titles in your data and Acct, Admin, and Sales are
the three you want to see.
 
This would be hard to keep up with since I add data every day and the dates
change. There are usually 5 - 10 enteries per day and a months worth of data
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

make selection in dropdown and auto click checkbox 1
Word Word 2010: help needed creating macro that cross references checkbox to a bookmarked drop down list 0
Save as PDF in Office 7
Dropdown items having Checkboxes 1
excel dropdown question 4
Checkbox issue - Checkbox overlapping when filter is applied 1
Macro to clear checkboxes 5
Filter query with checkboxes 0

Back
Top