How to extract target value from other cell [Solved/Closed]

Report
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
-
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
-
Hello,


I would like to request that
Suppose this line of code is working for Column B
MsgBox "You entered <" & Target & "> is Invalid"

this will show the message and the value or data that user enter in Column B

now what i actually want
If the above message used in Column C and show the value or data which he enter in Column B

please help me to solve it

1 reply

Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
462
Hi Smuneeb,

If Target refers to column C, but you like the value from column B then use:
target.offset(0,-1)

Best regards,
Trowa

Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
1
You have done a great job
Thanks
keep me in good book

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!