easy code for multiple labels

[halo6819]

hello all,
im writing code for a map of a hotel where i want users to be able to click a label and it shows the details of the room.

im looking for an easy way to call a function based on the label value.
something along the lines of

Private Sub Label2_Click()
    Call rooms (thisLable.Value)
End Sub

rather then having to type

Private Sub Label2_Click()
    Call rooms (Label2.Value)
End Sub
Private Sub Label3_Click()
    Call rooms (Label3.Value)
End Sub

400 times...

 

[tusharm]

See John Walkenbach's http://j-walk.com/ss/excel/tips/tip44.htm

 

[halo6819]

thank you, trying to adapt the code isnt going so hot, but this is definatly the right direction!