Button VBA To Refer To A Cell

[JIMBOB77]

Hi
I Have A Workbook.
In Sheet 1, Column A Contains Order Numbers.
In Column B I Have Buttons (1 Per Row).

In Sheet 2, Column A Contains The Same Order Numbers (But With Different Info)

What I Need To Do Is...
If I Click The Button In B24 It Takes Reference Of The Value In A24 Then Goes To Sheet 2 And Finds The Cell In Column A Of The Same Value.

I Need To Use The Same Macro For All Buttons (Eg It Refers To The Cell To The Left Of The Button)

 

[JIMBOB77]

Hi
Found A Formatting Error
Now Works...
Wondered If You Could Assist With A Slight Update....
Guessing I Need An Extra Argument In The Second Line Of Code.
Basically ...
When I Double Click The Cell In Column - If The Cell In Column E (Same Row) = "BOOKED" Then Exit Sub

 

[Yongle]

Below

    Cancel = True

Insert

    If UCase(Target.Offset(, 4)) = "BOOKED" Then Exit Sub

 

[JIMBOB77]

Perfect
Thanks For All Your Help

 

[James006]

As Expected I Get N/A
What Could Be Different About The Numbers??

A Number in one Sheet ... and a Text in the other Sheet ...

Watch out about blanks ...anywhere in your cells !!!

 

[Yongle]

thanks for the feedback