Prevent new line being added to Textbox

[sharky12345]

I have a Textbox on a Userform and I want to disable the user being able to add a new line when typing, by pressing the return or enter key.

Is there a keypress event which can be used to prevent this?

 

[sharky12345]

Got it;

Private Sub TextOtherComments_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
Select Case KeyCode
Case 13
KeyCode = 0
End Select
End Sub