I have a form on which I have put a textbox. I have linked that textbox to a cell on the sheet, so that the text in the textbox goes into the cell also. however, I find that the return keypress inside the textbox creates a square non-printing character, instead of a linefeed in the cell. is there any solution? Can the linked cell show the text of the textbox exactly as entered?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
problem with textbox linked with a cell
- Thread starter yukesh
- Start date
Richie(UK)
MrExcel MVP
- Joined
- May 17, 2002
- Messages
- 3,329
Hi yukesh,
Welcome to the board.
Try looking up in the VBE Help the KeyDown and KeyUp events. This should help you to get the desired result.
A quick example:
Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
'Check for the ENTER key
If KeyCode = 13 Then
MsgBox "You pressed the ENTER key"
End If
End Sub
HTH
Welcome to the board.
Try looking up in the VBE Help the KeyDown and KeyUp events. This should help you to get the desired result.
A quick example:
Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
'Check for the ENTER key
If KeyCode = 13 Then
MsgBox "You pressed the ENTER key"
End If
End Sub
HTH
Upvote
0
