PDA

View Full Version : Switch between userform and document?



clhare
11-12-2010, 06:51 AM
Is it possible to allow a user to click outside of a userform (in order to copy text from the document and then paste it into a userform text boxes)? I think I've seen something on this a long, long time ago, but never needed to use it until now.

Thanks!

fumei
11-12-2010, 10:04 AM
Yes. In the userform Properties, make the ShowModal = False. The default is True.

clhare
11-12-2010, 02:09 PM
Perfect! Thanks!