Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
T T is offline
external usenet poster
 
Posts: 41
Default xls data valadation question

i can create a list using the data validation btu would also like to be able
to type text in the same cell. is this possible?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 561
Default xls data valadation question

Upon declaring the DV click on the 'Errors alert' tab and de-select the
option 'Show Error error for illegal entries'
Micky


"t" wrote:

i can create a list using the data validation btu would also like to be able
to type text in the same cell. is this possible?

  #3   Report Post  
Posted to microsoft.public.excel.misc
T T is offline
external usenet poster
 
Posts: 41
Default xls data valadation question

thanks a bunch. it worked and solved my problem.

"מיכאל (מיקי) אבידן" wrote:

Upon declaring the DV click on the 'Errors alert' tab and de-select the
option 'Show Error error for illegal entries'
Micky


"t" wrote:

i can create a list using the data validation btu would also like to be able
to type text in the same cell. is this possible?

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
Data Valadation klafert Excel Worksheet Functions 2 February 1st 09 09:09 PM
Data Valadation Jeff Excel Worksheet Functions 4 December 15th 08 07:32 PM
Data Valadation claude jerry Excel Discussion (Misc queries) 5 April 14th 07 04:04 PM
Data Valadation - KimberlyC Excel Worksheet Functions 1 June 2nd 05 09:29 PM
Data Valadation help KimberlyC Excel Worksheet Functions 2 April 18th 05 01:24 AM


All times are GMT +1. The time now is 09:10 PM.

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

About Us

"It's about Microsoft Excel"