Excel crashes everytime I send focus from control to worksheet

[Daves_Solutions]

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]

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]

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

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

 

[Per1000IPDay8]

Exchange lots of mouse moves and clicks for a single key press!
Significantly improve working speed by using shortcuts (hot keys).
Avoid Repetitive Strain Injury!

EnergyKey http://www30.webSamba.com/SmartStudio