Posted to microsoft.public.excel.programming

Tom

external usenet poster

Posts: 4

Data validation question

Hi

I have a cell that contains a data validation field. The entries of the
dropdown box are "yes" and "no". Now I have the problem, that I want to
enter just the first character of the desired value, e.g. "y" for "yes". Is
it possible to get this work? It seems that Excel doesn't support this
feature. Many thanks in advance.

Tom

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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 Question	Bob Myers	Excel Worksheet Functions	1	December 18th 09 04:20 AM
Data Validation Question	DonkeyKong	Excel Discussion (Misc queries)	4	December 29th 08 07:10 PM
Data Validation Question	SiH23	Excel Discussion (Misc queries)	3	August 11th 07 11:29 PM
Data Validation Question	Andrew Mackenzie	Excel Discussion (Misc queries)	1	January 22nd 07 02:57 PM
Data validation question	Peter[_28_]	Excel Programming	4	October 11th 03 02:58 PM

All times are GMT +1. The time now is 08:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us