Please help. I have all the names of my students on column A. Let say A1 is
Sam. A2 is Peter. If I scroll right and click on QA1, I want to see the name
of Sam on a userform1.caption. If I click on M100, I want to see the A100
student's name on userform1.caption. It seems like there is something to do
with target but I just can't make it work with my limited programming
knowledge. Thanks for your help in advance.
Boogie

Right click on the sheet tab, Select View Code and paste in this code.

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
if target.count 1 then exit sub
if Target.column 1 then
Userform1.Caption = Cells(target.row,1).Value
Userform1.Show
End if
End Sub



--
Regards,
Tom Ogilvy

"boogie" wrote in message
...
Please help. I have all the names of my students on column A. Let say A1
is
Sam. A2 is Peter. If I scroll right and click on QA1, I want to see the
name
of Sam on a userform1.caption. If I click on M100, I want to see the A100
student's name on userform1.caption. It seems like there is something to
do
with target but I just can't make it work with my limited programming
knowledge. Thanks for your help in advance.
Boogie