Excel 2003, VBA: More Default values, cell locking

[network_engineer]

Hi all,

Would somebody please help me with a small piece of code?

I.e.
- if value in Column A = "To Do"; then values in column F & G = "N/A (To Do Item)"
- - if value in Column A = "Purchases"; then default (initial values) values in column F & G = "0"

Also, that if the value in Column A = "To Do"; then values in column F & G = "N/A (To Do Item)", then no other values can be entered into the columns G & G.

Thanks a lot, really appreciate the help!

Cheers,
Ben

 

[ayazgreat]

Could you please explain that if you are talking about entire column or cell, I mean to say that if it is a1, a2..........