LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default Data Validation List with Blanks that can be edited

Ohhh - thank you Dave - one simple check box unchecked and I am away!

Thanks again

"Dave Peterson" wrote:

There's a tab on the Data|Validation dialog that lets you specify what kind of
checking you want to use.

Look at that "Error Alert" tab and you'll see the options.

Belle wrote:

Hi There - thanks for reading my question.

I have a data validation list and I have included a blank, however I need
people to be about to type anything they like in the blank (edit it) as well
as still be able to see the list.

Thanks again.


--

Dave Peterson

 
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
Data Validation List with blanks Vinod[_2_] Excel Discussion (Misc queries) 1 July 4th 08 05:47 PM
MS Excel Data Validation, Ignore Blanks in List D Lu Excel Worksheet Functions 4 March 21st 08 02:44 AM
Blanks Data Validation List FARAZ QURESHI Excel Discussion (Misc queries) 4 March 13th 08 12:40 PM
blanks in data validation list dropdown confused Excel Worksheet Functions 7 June 7th 06 02:10 PM
Data Validation and Blanks in List GoneRural Excel Worksheet Functions 1 October 26th 05 05:03 PM


All times are GMT +1. The time now is 10:31 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"