Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 106
Default drop down list that i can also type regular text in as well

I want to be able to choose from options in a drop down and if not in the
drop down be able to type in another a different text.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,979
Default drop down list that i can also type regular text in as well

If the dropdown list was created by using Data Validation, you can go to
the Error tab in the Data Validation dialog box, and remove the check
mark from 'Show error alert after invalid data is entered'


Joyce wrote:
I want to be able to choose from options in a drop down and if not in the
drop down be able to type in another a different text.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Wrapping text in a Drop Down List Lisa Excel Discussion (Misc queries) 1 October 31st 07 05:09 PM
Text & symbols in the same drop-down list Rachael F Excel Discussion (Misc queries) 0 June 8th 06 12:48 PM
How can I wrap text in a drop down list? wrapped Excel Worksheet Functions 0 January 25th 06 05:53 PM
No drop down list type-ahead? Launen Excel Discussion (Misc queries) 2 October 18th 05 05:23 PM
How do I increase type size in an Excel drop down list? [email protected] Excel Discussion (Misc queries) 1 January 27th 05 01:27 AM


All times are GMT +1. The time now is 04:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"