M.S. Excel question re. How do I get my Data Val. constraints to appear at time of data entry thru a form?

Question

The data validation I have is that the enrty for certain fields must be through a drop down list. How do I get this drop down list to appear on a data form, at the moment anything can be entered in these fields when using the form, so it is all the same they need to pick it from the list so the formatting is not changed. You need to enter something off the drop down list when entering directly into the field...

Update:

Yes, I've got it working for direct entry - how do I get it working with entry via the form?

mark · Accepted Answer

select the cell where you want your data being validated
Select Data/validation

Under validation criteria/allow   select list

Under source, click once, and then click and drag down the cells where the list lives (I assumed you typed the list in a row of cells)

Note that I usually type my validation lists in another sheet within the same workbook to keep things looking clean

Trending News

M.S. Excel question re. How do I get my Data Val. constraints to appear at time of data entry thru a form?

1 Answer