I am just learning VB, can you help me with the code?

"Frank Kabel" wrote:

Hi
not completely save but
- select cell A4
- goto 'Data - Validation -. custom
- enter the formula
=A3<"X"

Note: This does not prevent copying data to this cell. If you need more
security you have to use VBA (an event procedure)


--
Regards
Frank Kabel
Frankfurt, Germany


JoeMNY wrote:
Greetings,

I'm sure this is possible but I can't figure it out. How can I
disable a cell based on input in another cell. Example:

A1=Powered
A2=Glider
A3=
A4=

If an "X" is placed in A3, I want A4 disabled (locked).

TIA