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

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

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

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