Click here to Skip to main content
15,891,204 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have created userform, If I open userform,am unable to edit in the active document with the userform opened. For example: If we press ctrl+f,the find functionality dialog box will be displayed,by keeping that dialog box opened we can scroll,edit etc in the active document.How to do it? Now its like, if alert message is displayed,we can't to do anything in active document until we close that alert message. I don't need like that. I need to handle both userform and active document simultaneously.

Thanks in advance.
Posted
Updated 19-Dec-14 18:09pm

1 solution

By default all userforms are opened as modal window.

To open UserForm in modeless mode, use:
VB
UserForm1.Show vbModeless


Please, see: Show Method[^]
 
Share this answer
 
Comments
Vidhya Raju 20-Dec-14 0:01am    
If I use vbmodeless,When I click in the active document,it is become hidden. I want userform to be visible If I click in the active document.
Maciej Los 20-Dec-14 10:30am    
It wasn't the part of question. Nevertheless...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28402531.html

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900