Increase Size Of Auto Fliter Drop Down Box

  • Thread starter Thread starter Mathew
  • Start date Start date
M

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
 
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
 
Back
Top