transferring multiline text from userform to worksheet - line break problem
The mousedown event is one of the events for a textbox - like click or
change:
Option Explicit
Public bBlockEvents As Boolean
Private Sub TextBox1_MouseDown(ByVal Button As Integer, ByVal Shift As
Integer, ByVal X As Single, ByVal Y As Single)
If bBlockEvents Then
bBlockEvents = False
Exit Sub
End If
If Button = 2 Then
MsgBox "Right Click " & bBlockEvents
End If
bBlockEvents = Not bBlockEvents
End Sub
--
Regards,
Tom Ogilvy
"Paul" wrote in message
oups.com...
Thanks so much, Tom! That works great!!!
I knew about the CTRL+V but what is the mousedown event and where
exactly do I program it?
Thanks again,
Paul
|