Previous Topic Next Topic

If Statement in Excel that locks a cell

Closed
Alex - 23 Dec 2009 à 12:50
lfefil Posts 60 Registration date Monday 21 December 2009 Status Member Last seen 25 December 2009 - 24 Dec 2009 à 10:53
Hello,

I'm trying to create an IF statement in Excel 2003

If a cell is equal to a certain text string, then lock the cell and display a text string or a message box telling the user to enter a value in another cell, otherwise, the user should be able to enter text into the cell without erasing the formula.

Is this possible without writing vba code into the spreadsheet?
Related:

1 response

Réponse 1 / 1
lfefil Posts 60 Registration date Monday 21 December 2009 Status Member Last seen 25 December 2009 10
24 Dec 2009 à 10:53
no this is not so possible but you can use the validation option for it have you try it?

Similar discussions

If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
How to disable Magazine lock screen on Infinix Zero 5 X603
Kiviangu -
Nomeer -

8 responses
Arrow keys scrolling in Excel
Deb -
Upthewall -

24 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses