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!