How to extract target value from other cell

Solved/Closed
smuneeb Posts 77 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - Nov 9, 2015 at 03:47 PM
smuneeb Posts 77 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - Nov 10, 2015 at 01:46 PM
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

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
Nov 10, 2015 at 11:07 AM
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
smuneeb Posts 77 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 1
Nov 10, 2015 at 01:46 PM
You have done a great job
Thanks
keep me in good book
0