Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 13th 06, 08:50 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,560
Default pick from 'drop down list' OR enter text in cell

Greetings,
I often use the drop down list feature from data validation in many cells on
forms for ease of form filling.
Would like to do same but also allow the user to type in her own text if
nothing on the drop down list is suitable.
Is this possible?
Thanks

  #2   Report Post  
Old December 13th 06, 08:53 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,886
Default pick from 'drop down list' OR enter text in cell

Hi David

Yes
On the DV validation dialogue, go to the error tab and untick the box.

--
Regards

Roger Govier


"David" wrote in message
news
Greetings,
I often use the drop down list feature from data validation in many
cells on
forms for ease of form filling.
Would like to do same but also allow the user to type in her own text
if
nothing on the drop down list is suitable.
Is this possible?
Thanks



  #3   Report Post  
Old December 13th 06, 10:05 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,560
Default pick from 'drop down list' OR enter text in cell

Thanks Roger,
That has been a tremendous help



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
Sumproduct issues SteveDB1 Excel Worksheet Functions 25 June 3rd 09 04:58 PM
change size of in cell drop down list yep Excel Discussion (Misc queries) 3 January 27th 06 09:42 PM
How can I wrap text in a drop down list? wrapped Excel Worksheet Functions 0 January 25th 06 05:53 PM
How do I make a drop down list to pick from for a cell in Excel bbiernbaum Excel Discussion (Misc queries) 2 June 15th 05 02:32 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM


All times are GMT +1. The time now is 05:33 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017