MsgBox-write vba to pick up

[ag23035]

hi all, I have this excel worksheet 2007 and wish to have msgbox popup if there is a value entered.
example, in column A theres text "CASH" or "STOCK" or "#N/A", so in column B and C needs to put in value, so if its "CASH" value must be entered in column B and for "STOCK" value must be entered in column C.
I want to be able to write vba to pick up that if its text in column A says "CASH" and I enter a value in column C instead of B then msgbox error should pop up warning me thats its in the wrong column.
can someone please help???
thank you sooo much!

[Colin Legg]

Hi,

Have you considered using data validation for this? It has some shortfalls but it will be much more straightforward for you to implement than VBA.

[ag23035]

Hi,

Have you considered using data validation for this? It has some shortfalls but it will be much more straightforward for you to implement than VBA.

Hi Colin, I'm sorry I'm new to this, what's data validation? any suggestion would be helpful =)