Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox)
Hi, I would like to create a listbox that looks and functions exactly like the ones in the Pivot tables where by default all are selected or user can choose as many as they want. Is there a control for me to do this (listbox + checkbox) or should I use a regular listbox? Thanks, Joe -- modjoe23 ------------------------------------------------------------------------ modjoe23's Profile: http://www.excelforum.com/member.php...o&userid=26376 View this thread: http://www.excelforum.com/showthread...hreadid=396510 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: Creating listbox similar to the one in Pivot table (Listbox+C
ModJoe:
If I understood you correctly, what you want to do is 'Auto Filter', which is a very simple task. Here's what you'll need to do: If your spreadsheet is organized as a list, simply click a cell in list. / If not, highlight a single cell or row containing your column headers. Next, on the standard toolbar, click 'Data' - 'Filter' - 'Autofilter'...and you're done! You'll notice each of your column headers now has a 'list box' look with all entires selected by default. The list may be sorted by blank, non-blank, custom, top 10, or any one or all of the entries. If at any time you decide you want to turn off the Auto Filter, simply click 'Data' - 'Filter' - 'Auto Filter' to remove the check mark. I hope this is what you're looking for. Much simpler than adding controls. Let me know if you have questions. :) "modjoe23" wrote: Hi, I would like to create a listbox that looks and functions exactly like the ones in the Pivot tables where by default all are selected or user can choose as many as they want. Is there a control for me to do this (listbox + checkbox) or should I use a regular listbox? Thanks, Joe -- modjoe23 ------------------------------------------------------------------------ modjoe23's Profile: http://www.excelforum.com/member.php...o&userid=26376 View this thread: http://www.excelforum.com/showthread...hreadid=396510 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox)
Hi Modjoe23,
Just use a regular list box, with MultiSelect set to true. There is a property to make it show check boxes, but I've never been impressed by it. Regards Stephen Bullen Microsoft MVP - Excel Professional Excel Development The most advanced Excel VBA book available www.oaltd.co.uk/ProExcelDev |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox)
I wasn't aware that it was that simple, sorry and thanks -- modjoe23 ------------------------------------------------------------------------ modjoe23's Profile: http://www.excelforum.com/member.php...o&userid=26376 View this thread: http://www.excelforum.com/showthread...hreadid=396510 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating pivot table with similar columnames | Excel Discussion (Misc queries) | |||
Pivot Table Field's Item Listbox | Excel Programming | |||
Fill a Listbox with Values from a Pivot Table Field - an Example | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Listbox w/CheckBox Options | Excel Programming |