change appearance of text in drop down list

**sick stigma** · 06-22-2007, 08:54 PM

Hello All,
is it possible to change the font size of text in drop down list?
is it possible to enable scrolling in drop down list?
is it possible to make drop down box longer?
any and all help is appreciated!!!!!!!

**starguy** · 06-23-2007, 02:07 AM

Originally Posted by sick stigma

Hello All,
is it possible to change the font size of text in drop down list?
is it possible to enable scrolling in drop down list?
is it possible to make drop down box longer?
any and all help is appreciated!!!!!!!

Hi
Following link may help you.

http://www.contextures.com/xlDataVal10.html

**VBA Noob** · 06-23-2007, 02:08 AM

See link

Data Validation Font Size and List Length

VBA Noob

**sick stigma** · 06-23-2007, 12:21 PM

Hey Folks,
I've tried to recreate the worksheet you referenced (see attached).
i can't get it to work. can you tell me what i'm doing wrong?
thank you,
jack