Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Font of advanced filter
Is it possible to increase the font of the advanced filter list?
I know we can do it for the validation (http://www.contextures.com/xlDataVal08.html#Font) Can we modify this code for the advanced filter too? Thanks Catherine |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Font of advanced filter
Can someone help me with the autofilter font
Thanks Catherine "Catherine" wrote: Is it possible to increase the font of the advanced filter list? I know we can do it for the validation (http://www.contextures.com/xlDataVal08.html#Font) Can we modify this code for the advanced filter too? Thanks Catherine |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Font of advanced filter
Clicking the Autofilter dropdown arrow doesn't trigger a worksheet
event, so you can't use that code to increase the size of the AutoFilter dropdown font. You could change it to increase the zoom if one of the heading cells is clicked. Then click on the cell before you click on the arrow. Catherine wrote: Can someone help me with the autofilter font Thanks Catherine "Catherine" wrote: Is it possible to increase the font of the advanced filter list? I know we can do it for the validation (http://www.contextures.com/xlDataVal08.html#Font) Can we modify this code for the advanced filter too? Thanks Catherine -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Font of advanced filter
Thanks Debra it's working for autofilter too, but you need to select the cell
before If I understand, we cannot modify the code of the macro (Zoom in when any cell with a data validation list is selected) for the autofilter "Debra Dalgleish" wrote: Clicking the Autofilter dropdown arrow doesn't trigger a worksheet event, so you can't use that code to increase the size of the AutoFilter dropdown font. You could change it to increase the zoom if one of the heading cells is clicked. Then click on the cell before you click on the arrow. Catherine wrote: Can someone help me with the autofilter font Thanks Catherine "Catherine" wrote: Is it possible to increase the font of the advanced filter list? I know we can do it for the validation (http://www.contextures.com/xlDataVal08.html#Font) Can we modify this code for the advanced filter too? Thanks Catherine -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter - filter rows < | Excel Discussion (Misc queries) | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |