B bikash New Member Sep 7, 2012 #1 Eg: Row Coloumn A B C 1 =A1*B1 2 3 How to prevent user from entering value in C1 and display a msg asking them to enter values in A1 and B1 to get result?
Eg: Row Coloumn A B C 1 =A1*B1 2 3 How to prevent user from entering value in C1 and display a msg asking them to enter values in A1 and B1 to get result?
S sdsurzh Member Sep 7, 2012 #2 Hi Bikash, Please visit the following site. http://office.microsoft.com/en-us/excel-help/apply-data-validation-to-cells-HP010072600.aspx Thanks, Suresh Kumar s
Hi Bikash, Please visit the following site. http://office.microsoft.com/en-us/excel-help/apply-data-validation-to-cells-HP010072600.aspx Thanks, Suresh Kumar s
K kaushik03 Member Sep 7, 2012 #3 Hi bikash, Can you plz clarify the following: 1)whether you are entering the data manually or from drop down list? 2)Do you want to prevent user to enter any data at C1( or entire COL C) or certain range of data? Meanwhile, plz check here if it suits your requirement.. http://speedy.sh/dFTt9/DataValidation.xlsm Regards, Kaushik
Hi bikash, Can you plz clarify the following: 1)whether you are entering the data manually or from drop down list? 2)Do you want to prevent user to enter any data at C1( or entire COL C) or certain range of data? Meanwhile, plz check here if it suits your requirement.. http://speedy.sh/dFTt9/DataValidation.xlsm Regards, Kaushik
