ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   xls data valadation question (https://www.excelbanter.com/excel-discussion-misc-queries/258626-xls-data-valadation-question.html)

T

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?

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

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?


T

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?



All times are GMT +1. The time now is 12:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com