Posted to microsoft.public.excel.programming

Rick[_38_] Rick[_38_] is offline

external usenet poster

Posts: 1

xl2007 data validation drop-down box

I have a list of 171 world currencies of which the user must select one. The
dropdown box displays only 8 at a time.
1. is there a waqy to expand the number displayed, and;
2. is there a way s/he can key in the first letter and have the box display
the list beginning with that letter?

Much appreciated.

Thanks.

.... rick

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data Validation drop-down	Michelle	Excel Discussion (Misc queries)	5	March 17th 21 05:18 AM
Data Validation in XL2007 suddenly stops functioning	ker_01	Excel Discussion (Misc queries)	0	January 29th 10 11:58 PM
Data validation drop-down box	damanwitdaplan	Excel Discussion (Misc queries)	1	March 6th 08 02:53 PM
Data Validation - Drop Down Box	L2Lafferty	Excel Worksheet Functions	3	December 28th 06 07:25 PM
Data Validation - Drop Down	John	Excel Worksheet Functions	3	April 25th 06 03:50 AM

All times are GMT +1. The time now is 11:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us