I have an embedded control in my spreadsheet and everytime that the user
presses the tab key I send the focus to the next cell adjacent to the
control. However each time that this little piece of code runs it crashes
excel.

If I put a text box in the cell and send the focus to the textbox I incur no
problems.

Any explanations or help that you can give me would be greatly appreciated.
Thanks in advance!

Assuming a combobox added from the Control Toolbox tool bar, this works fine
for me:

Private Sub ComboBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, _
ByVal Shift As Integer)
If KeyCode = 9 Then
ComboBox1.TopLeftCell(1, 4).Select
Selection.Value = ComboBox1.Text
End If
End Sub

Regards,
Greg

"Daves_Solutions" wrote:

I have an embedded control in my spreadsheet and everytime that the user
presses the tab key I send the focus to the next cell adjacent to the
control. However each time that this little piece of code runs it crashes
excel.

If I put a text box in the cell and send the focus to the textbox I incur no
problems.

Any explanations or help that you can give me would be greatly appreciated.
Thanks in advance!

"Greg Wilson" wrote:

Assuming a combobox added from the Control Toolbox tool bar, this works fine
for me:

Private Sub ComboBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, _
ByVal Shift As Integer)
If KeyCode = 9 Then
ComboBox1.TopLeftCell(1, 4).Select
Selection.Value = ComboBox1.Text
End If
End Sub

Regards,
Greg

"Daves_Solutions" wrote:

I have an embedded control in my spreadsheet and everytime that the user
presses the tab key I send the focus to the next cell adjacent to the
control. However each time that this little piece of code runs it crashes
excel.

If I put a text box in the cell and send the focus to the textbox I incur no
problems.

Any explanations or help that you can give me would be greatly appreciated.
Thanks in advance!

Thanks, this works fine on my developing computer so I (assume) it will be
fine at work. I appreciate it.