Christina has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Protecting formulas in cells
Hello,
Please can you help me resolve my query? I have a cell which has data validation in it to produce a drop down list. However I would like to link this cell as follows:
=IF(Left(D17,3)="450","Please select from the drop down list","")
Note: Cell D17 is a drop down list that they can select a series of numbers from 110 to 450
I can write the formula but the problem I have is when it appears "Please select from the drop down list", and they select a code, this then deletes the formula for the next time and as this is a form used by many people it will cause confusion.
Do you know if this is even possible to do?
Thank you for your help
RE: Protecting formulas in cells
Hi Christina, thanks for your query. This is possible to do...using code. The second you select an item from a drop down list on a cell, that value will indeed overwrite the cell value, eradicating your formula.
Why not put your formula in the adjacent cell and use a colon at the end of the text to direct the user, as so:
=IF(Left(D17,3)="450","Please select from the drop down list:","")
Otherwise, I'm afraid you'll need to code any text that appears conditionally dependent on input from the user!
Anthony
