Keyboard keys are not working after running macro

Any Idea on this?

Check some code here for fetching data from list box ‼

It is obvious that there is something in code.. that is doing all this..

Provide the whole code..
may be we can help you...

Regards.
Vikas Gautam

code is simple.. which i am using in click event & doing no harm..

Private Sub ListBox_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
    If KeyAscii = 13 Then
    If ListBox.ListIndex < 0 Then
        TextBox1.Text = "XYZ"
    Else
        TextBox1.Text = "ABC"
    End If
    ListBox.Visible = False
    End If
End Sub

Thanks for reply..

Originally Posted by Andy Pope

So if you start with a working excel and display the userform and then without pressing Enter you use the form and close it does the issue arise?

No it causes issue after i use enter to select item in list box & close list box then after.

Thanks for reply.

error i got while debugging is..

Runtime error '-2147417848 (80010108)' The object invoked has disconnected from its clients in Excel VBA macro

this is due to i guess i am trying to close list box from textbox module while item in the list box is selected by pressing enter key..