Previous Topic Next Topic

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

Answer 1 / 1
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
 491
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.
0
Report
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
0
Ask a question