Forum home » Delegate support and help forum » Microsoft Excel Training and help » Protecting formulas in cells
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Protecting formulas in cells
Resolved · Urgent Priority · Version 2003
Reply Fri 11 Feb 2011, 13:30Delegate Christina said...
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
For upcoming training course dates see: Pricing & availability
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
Fri 18 Feb 2011: Automatically marked as resolved.
|