Textbox1_Click; Do we have textbox1_click on Userform?

[pedie]

Hi, do we have textbox1_click on Userform?
I'm trying to do something on textbox click [if this is possible to triger macro in single click...]

Thanks

 

[Norie]

Well the short answer is no, there isn't a Click event.

You can find all the events of any control by selecting it from the left dropdown in the userform module code window, then looking at the list in the right dropdown.

 

[pedie]

Norie, thanks for confirming...At times, even when i dont see things there...happens tp be there...so...


Thanks again!

 

[Jaafar Tribak]

You can use the MouseDown event as follows :

Private Sub TextBox1_MouseDown _
(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
    If Button = 1 Then MsgBox "hello!"
End Sub

 

[pedie]

Jaafar Tribak, the other I was in rush and forgot to come back to get this...
Jaafar, thanks for helping...thanks for the workaround!