"Mat P:son" wrote:

Well, it seems to work just fine on my box (but that's what you'd expect,
isn't it?)

Have you tried breaking into the VBA code and see exactly when the crash
occurs (put a breakpoint on e.g. the first line after the If statement)? Or
don't you even get that far?

/MP

"Daves_Solutions" wrote:

Everytime I run the following procedure excel crashes.
Private Sub cmbDesc_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal
Shift As Integer)
If KeyCode = 9 Then
NewInventory.Cells(9, 4) = cmbDesc.Text
cmbDesc.Visible = False
NewInventory.Cells(9, 5).Select
End If
End Sub
I have several other procedures that are similar that run fine. All I am
trying to do is send the focus to the next cell in an invoice that I created
from an embedded combo box.

Any suggestions or help would be greatly appreciated. Thank you in advance
for your time.
Dave
I have stepped through the code and it works fine until the end sub. As soon
as it leaves the sub and the focus return back to the worksheet excel
crashes. I have added a text box and sent the focus there and it works fine.
It even works fine once in ten or twenty times. Who knew? Any other ideas??