Hi All,
I need your help. In column “A” I have data. As shown below
LOCKA
LOCKB
LOCKC
LOCKD
What I am trying to is, if column A contains LOCKA, LOCKB, LOCKC then only user can enter data into B column. As shown below
Col – A Col – B
LOCKA XXX
LOCKB XXX
LOCKC XXX
If column A contains LOCKD & user trying to enter data then code should not accept the data & show msgbox that “Its LOCKD you can’t enter data”. I need to do this Via VBA.
Col – A Col – B
LOCKD Error MsgBox & Should not accept the data.
Request you to please help with this.
Bookmarks