Solved: UserForm KeyDown Button Forces cursor to jump to next textbox

[ChloeRadshaw]

I have a bunch of textboxes on a multipage - Each of these have wordwrap set to true, multiline set to true and enterkeybehaviour set to true.


If I press the down key in one of these fields I notice that the cursor moves to THE NEXT input box which I definitely do not want.

Does anyone know how to prevent this??

[Kenneth Hobs]

That would be something other than what one would typically expect.

Here is one way.
Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = 40 Then SendKeys "{UP}"
End Sub

[mikerickson]

This avoids SendKeys. The UF completely ignores the {up} key when TextBox1 has the focus.
Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = 40 Then KeyCode = 0
End Sub

[ChloeRadshaw]

This avoids SendKeys. The UF completely ignores the {up} key when TextBox1 has the focus.
Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = 40 Then KeyCode = 0
End Sub

Thanks - But I dont see why this is necessary - Why is the textbox doing this in the first place?

Is this a property I have set???

[Kenneth Hobs]

It is working as designed. When you do that in an Excel cell in goes to the next cell down. That sort of navigation goes by control type as well.

[ChloeRadshaw]

Are you sure about this?

This only happens for multi line text boxes from the looks of things. Is there anything on MSDN which confirms this??

[ChloeRadshaw]

I would like to close this but I have not had any confirmation that this is working as designed

Does anyone have a link to a reliable source where this is discussed please.

Thank you