ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can you use the validate function in a data form in Excel? (https://www.excelbanter.com/excel-worksheet-functions/60077-can-you-use-validate-function-data-form-excel.html)

Jolly

Can you use the validate function in a data form in Excel?
 
I am trying to simplify the data entry by using the "Form" function from the
"Data" menu. In the data entry fields in the spreadsheet I am using data
validation to standardise the responses, and I was interested in finding out
how / if Excel was able to utilise the same data validation in the "Form"
view as it uses in the spreadsheet?


All times are GMT +1. The time now is 06:23 PM.

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