How to extract target value from other cell

Solved/Closed

smuneeb Posts 67 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - Nov 9, 2015 at 03:47 PM
smuneeb Posts 67 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 audio from video vlc - Guide
Gta san andreas how to lock on target pc - Guide
How to insert rows in excel automatically based on cell value without vba ✓ - Excel Forum
What function can automatically return the value in cell c77 ✓ - Excel Forum
If a cell has text then return value ✓ - Excel Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
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.

smuneeb Posts 67 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

Similar discussions

Zip password :- what is the zip password?

kmspico password protected

Have downloaded KMSPico but I need the password

help me to add particular cells

If cell A1 has text then cell B2 has today's Date

Similar discussions

Subscribe To Our Newsletter!