active cell??

[bposaner]

All

I've got a score grid, say B2-V22(with the 1st row&col with names.) So if Team A plays Team G, you just look for TeamA in the first col and then Team G in the First Row. And where they intersect you enter the score.

What I want to do is that say I click cell J12 I want to be able to have a Function that will tell me the two teams involved.
So as I select other cells the names displays will also change.

I think "active cell" might play a part, but i'm not sure how.

BP

 

[Haluk]

On 2002-10-28 11:08, bposaner wrote:
All

I've got a score grid, say B2-V22(with the 1st row&col with names.) So if Team A plays Team G, you just look for TeamA in the first col and then Team G in the First Row. And where they intersect you enter the score.

What I want to do is that say I click cell J12 I want to be able to have a Function that will tell me the two teams involved.
So as I select other cells the names displays will also change.

I think "active cell" might play a part, but i'm not sure how.

BP

Hi;

i am not sure if this is the correct answer to your question, but it may give you an idea...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox "Teams involved are; " & Cells(ActiveCell.Row, 1) & " and " & Cells(1, ActiveCell.Column)
End Sub

 

[bposaner]

Thanks

BP