Excel crashes on simple procedure
"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 think that for some reason the computer that is to run this has a problem.
I can run this code on three other computers and like you say it worlks fine
for you??
Thanks for your time and help.
dave
|