LinkBack URL
About LinkBacks
I used keypress code in one of forms, after running following command non of my keyboard is working in excel. when i am restarting excel everything is fine. what could be the reason?
Thanks
Please Login or Register to view this content.
Keyboard keys are not working after running macro
I used keypress code in one of forms, after running following command non of my keyboard is working in excel. when i am restarting excel everything is fine. what could be the reason?
ThanksPlease Login or Register to view this content.
Last edited by excelliot; 07-24-2014 at 06:13 AM.
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..
Thanks for reply..Please Login or Register to view this content.
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?
Basically there is nothing in the code or descripton you have provided that should render keyboard inactive. Something else in your project must be occuriring and without see that we are unable to help.
No it causes issue after i use enter to select item in list box & close list box then after.Originally Posted by Andy Pope
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..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks