If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Increase Size Of Auto Fliter Drop Down Box
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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.716 / Virus Database: 472 - Release Date: 05/07/2004 |
#2
|
|||
|
|||
Increase Size Of Auto Fliter Drop Down Box
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 increase the depth of the Auot filter drop down box. I would be grateful for any assistance Cheers, Mathew --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.716 / Virus Database: 472 - Release Date: 05/07/2004 . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
auto list size | capgunkidd | Worksheet Functions | 1 | May 13th, 2004 05:08 PM |
Auto size row | mgolden | Worksheet Functions | 2 | February 11th, 2004 06:38 AM |
Size of drop box | John Babcock | Charts and Charting | 1 | January 11th, 2004 11:48 PM |
Filter drop down menu font size | Jim Sullivan | Worksheet Functions | 0 | September 19th, 2003 02:36 PM |