ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Double Click Event on Image (https://www.excelbanter.com/excel-programming/408401-double-click-event-image.html)

Redan

Double Click Event on Image
 
Hello,

Is it possible to get the .Tag when I double click on an Image without
having to specify the name of the Image control and instead using something
Parent or Me to ?

Thanks in advance!

Example :


Private Sub hello(strName As String)
MsgBox strName
End Sub

Private Sub Image1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
hello Image1.Tag
End Sub

Private Sub Image2_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
hello Image2.Tag
End Sub

Private Sub Image3_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
hello Image3.Tag
End Sub

Private Sub Image4_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
hello Image4.Tag
End Sub




All times are GMT +1. The time now is 03:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com