Increase Size Of Auto Fliter Drop Down Box

[Mathew]

Good evening all,

I am looking for some code so that I can increase the Depth of the auto -fliter drop down box, ie to increase the number of entries
visible, but without changing the font size.

Having searched Google, there are many reccomendations for increasing the apparent size of the font ( by using zoom), but cannot
find anything to help with increasing the size of the box itself.

I have found some very useful code to increase the size (width) of the Name Box, and would appreciate some help to similarly
increase the depth of the Auot filter drop down box.

I would be grateful for any assistance

Cheers,

Mathew

 

[Mark E. Philpot]

Hi,

I have just finished a Triple Filter Project for someone
else. It uses a userform with based on 3 columns and 3
choices. The user can select 0 to 3 choices for each of
the 3 filters. The results are the values for each
combined choice of each line. Huh?

example:
filter 1= a & C results= total value of a & c
filter 2= A & b " a & b
filter 3= b & c " b & c

where a,b,c are the cell criteria

If you would like a copy, send me an email. If you want it
to fit your data, send a sample sheet of your range.

regards
Mark

-----Original Message-----
Good evening all,

I am looking for some code so that I can increase the

Depth of the auto -fliter drop down box, ie to increase
the number of entries

visible, but without changing the font size.

Having searched Google, there are many reccomendations

for increasing the apparent size of the font ( by using
zoom), but cannot

find anything to help with increasing the size of the box itself.

I have found some very useful code to increase the size

(width) of the Name Box, and would appreciate some help to
similarly