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

Question

Previous Topic Next Topic

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

Report

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

How to extract target value from other cell
Extract a specific word from cells and count ✓ - Forum - Word
Extract values from non blank cells in a column ✓ - Forum - Programming
Excel - Send value of cell to target - How-To - Excel
Send value of cell to target ✓ - Forum - Office Software
2 macros in one sheet targeting same cells ✓ - Forum - Excel

1 reply

Ask a question

TrowaD · Answer 1 · 2015-11-10T11:07:05-0500

Answer 1 / 1

TrowaD

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

462
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.

Report

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

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

1 reply

Your reply

Subscribe To Our Newsletter!