View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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