Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Binge Fischer   on Feb 23 In MS Office Category.

  
Question Answered By: Abel Fischer   on Feb 23

If I didn't get wrong,i think this helps:

Put this in worksheet's code.I assume the data is in Range("A1:C6")

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As
Range)
If(ActiveCell.Row<7) and (ActiveCell.Column=1 or ActiveCell.Column=2)
then
Range("C" & ActiveCell.Row).Select
Msgbox Selection.Value
'Delete Msgbox line and put the Code with using Selection
End If
End Sub

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Scatter Chart Or get search suggestion and latest updates.


Tagged: