Applying Data Validation to Allow Only Formulas

Hi everyone,

Is there way in excel to allow entry in a cell to be a formula only through data validation?

Hi!

This short VBA code, in the worksheet object, can do the work. In this case it is only for Column A (as an example):

Please Login or Register  to view this content.

Your profile does not say what version of Excel. If you are using 2013 or later, you might be able to use Data Validation -> custom -> formula is =ISFORMULA(A1)=true to force entry of a formula in A1. I cannot test it in my older version of Excel, since the ISFORMULA() function does not show up until Excel 2013. Something like that should be able to work. Event code like that proposed might be the best way if you need it to be compatible with pre2013 versions of Excel.

If that was useful, I might suggest the following help file (I never use data validation, so this is where I got the idea): https://support.office.com/en-us/art...0-f010b1159828