Increase Size Of Auto Fliter Drop Down Box


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
 
Ad

Advertisements

M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top