xls data valadation question

T

t

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?
 
×

מיכ×ל (מיקי) ×בידן

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

t

thanks a bunch. it worked and solved my problem.

מיכ×ל (מיקי) ×בידן said:
Upon declaring the DV click on the 'Errors alert' tab and de-select the
option 'Show Error error for illegal entries'
Micky
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

data - validation - list question 2
Excel 2000 Data Valadation, VLookUp, NameRange, with multiple crit 1
Data Valadation 2
Data Valadation 4
using VLookup with two variables to get results 2
How do I Designating a number with letters? 8
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data Valadation 5

Top