Dear Experts,
While using an userform, is it not possible to swap to other files in the window?
I.e Alt+tab function is not working while an userform is opened.
Is there any solution to avoid this problem???
Regards,
Alex
Dear Experts,
While using an userform, is it not possible to swap to other files in the window?
I.e Alt+tab function is not working while an userform is opened.
Is there any solution to avoid this problem???
Regards,
Alex
Last edited by sivdin; 04-28-2009 at 06:35 AM.
You would need to show the userform modeless.
Either by setting the Modal property to False or using the parameter of the Show method.
The Alt+Tab will not take you off the userform, but you can click the workbook and then use Alt+Tab![]()
Please Login or Register to view this content.
You need to make the userform modeless. In the UserForm's properties change the showModal property to False. You can set it in the initialize event if you want
![]()
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thank you everybody
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks