How to do copy-and-paste easily between a userform and a blank Word

Hi,

I have created a userform which takes input of information.
When I move the mouse out of the userform and click on another Word
document to copy some information, it forbids me to do so. I can't
copy any information on that Word document which I want to paste to
the userform. May I ask how I can switch to another Word document
from a userform, copy information from there and paste it to the
userfom conveniently? Thank you.

Mike

Tony
Sat Mar 29 19:53:57 PDT 2008

On Mar 30, 1:23=A0pm, cyberdude <honchor...@gmail.com> wrote:
> Hi,
>
> I have created a userform which takes input of information.
> When I move the mouse out of the userform and click on another Word
> document to copy some information, it forbids me to do so. =A0I can't
> copy any information on that Word document which I want to paste to
> the userform. =A0May I ask how I can switch to another Word document
> from a userform, copy information from there and paste it to the
> userfom conveniently? =A0Thank you.
>
> Mike

By default the userformm.Show method displays the form in Modal mode.

Display the form as modeless
eg using YourUsefromeName.Show False


This will allow you to change focus from and back to the form.

Hope this Helps.

Cheers!
TonyS

Definition:
MODAL forms are forms which require user input before any other
actions can be taken place. In other words, a modal form has exclusive
focus in that application until it is dismissed. When showing a modal
form, the controls outside this modal form will not take user
interaction until the form is closed. The internal MsgBox and InputBox
forms are examples of modal forms.

Doug
Sat Mar 29 19:55:20 PDT 2008

Use

[formobject].Show Modal

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"cyberdude" <honchorlee@gmail.com> wrote in message
news:7b2edad1-7200-4961-bcb8-33ffcd4361d7@e6g2000prf.googlegroups.com...
> Hi,
>
> I have created a userform which takes input of information.
> When I move the mouse out of the userform and click on another Word
> document to copy some information, it forbids me to do so. I can't
> copy any information on that Word document which I want to paste to
> the userform. May I ask how I can switch to another Word document
> from a userform, copy information from there and paste it to the
> userfom conveniently? Thank you.
>
> Mike

cyberdude
Sat Mar 29 21:05:18 PDT 2008

On 3$B7n(B30$BF|(B, $B>e8a(B10$B;~(B55$BJ,(B, "Doug Robbins - Word MVP"
<d...@REMOVECAPSmvps.org> wrote:
> Use
>
> [formobject].Show Modal
>
> --
> Hope this helps.
>
> Please reply to the newsgroup unless you wish to avail yourself of my
> services on a paid consulting basis.
>
> Doug Robbins - Word MVP
>
> "cyberdude" <honchor...@gmail.com> wrote in message
>
> news:7b2edad1-7200-4961-bcb8-33ffcd4361d7@e6g2000prf.googlegroups.com...
>
>
>
> > Hi,
>
> > I have created a userform which takes input of information.
> > When I move the mouse out of the userform and click on another Word
> > document to copy some information, it forbids me to do so. I can't
> > copy any information on that Word document which I want to paste to
> > the userform. May I ask how I can switch to another Word document
> > from a userform, copy information from there and paste it to the
> > userfom conveniently? Thank you.
>
> > Mike- $Bp,i6Ho0zMQJ8;z(B -
>
> - $Bp}<(Ho0zMQJ8;z(B -

Hi,

Thank you for your suggestions. Both methods work perfectly for my
purpose.

However, I have got another question about the copy-and-paste action.
When
I put my mouse on the useform and right click it, it does not
pop up a list of actions from which I can choose to copy, paste or do
other things.
I need to enter "Ctrl-V" to paste something to the input boxes. May I
ask
how to make the pop-up list of actions (like copy, paste, ....) to
show up? Thank you.

Mike

Doug
Sun Mar 30 01:52:42 PDT 2008

You will have to be content with using Ctrl+V

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"cyberdude" <honchorlee@gmail.com> wrote in message
news:cc32427e-5c18-4069-972b-95f86b956dc3@h11g2000prf.googlegroups.com...
> On 3$B7n(B30$BF|(B, $B>e8a(B10$B;~(B55$BJ,(B, "Doug Robbins - Word MVP"
> <d...@REMOVECAPSmvps.org> wrote:
>> Use
>>
>> [formobject].Show Modal
>>
>> --
>> Hope this helps.
>>
>> Please reply to the newsgroup unless you wish to avail yourself of my
>> services on a paid consulting basis.
>>
>> Doug Robbins - Word MVP
>>
>> "cyberdude" <honchor...@gmail.com> wrote in message
>>
>> news:7b2edad1-7200-4961-bcb8-33ffcd4361d7@e6g2000prf.googlegroups.com...
>>
>>
>>
>> > Hi,
>>
>> > I have created a userform which takes input of information.
>> > When I move the mouse out of the userform and click on another Word
>> > document to copy some information, it forbids me to do so. I can't
>> > copy any information on that Word document which I want to paste to
>> > the userform. May I ask how I can switch to another Word document
>> > from a userform, copy information from there and paste it to the
>> > userfom conveniently? Thank you.
>>
>> > Mike- $Bp,i6Ho0zMQJ8;z(B -
>>
>> - $Bp}<(Ho0zMQJ8;z(B -
>
> Hi,
>
> Thank you for your suggestions. Both methods work perfectly for my
> purpose.
>
> However, I have got another question about the copy-and-paste action.
> When
> I put my mouse on the useform and right click it, it does not
> pop up a list of actions from which I can choose to copy, paste or do
> other things.
> I need to enter "Ctrl-V" to paste something to the input boxes. May I
> ask
> how to make the pop-up list of actions (like copy, paste, ....) to
> show up? Thank you.
>
> Mike

smiley_reader
Mon Jun 09 13:33:01 PDT 2008

Use it where? I have the same problem. I created a little form, and want
people to be able to copy & paste it into an Outlook message. When it's
locked so they can tab from field to field, you can't select the two lines &
copy them!?

Many thanks for any help!
smiley_reader

"Doug Robbins - Word MVP" wrote:

> Use
>
> [formobject].Show Modal
>
> --
> Hope this helps.
>
> Please reply to the newsgroup unless you wish to avail yourself of my
> services on a paid consulting basis.
>
> Doug Robbins - Word MVP
>
> "cyberdude" <honchorlee@gmail.com> wrote in message
> news:7b2edad1-7200-4961-bcb8-33ffcd4361d7@e6g2000prf.googlegroups.com...
> > Hi,
> >
> > I have created a userform which takes input of information.
> > When I move the mouse out of the userform and click on another Word
> > document to copy some information, it forbids me to do so. I can't
> > copy any information on that Word document which I want to paste to
> > the userform. May I ask how I can switch to another Word document
> > from a userform, copy information from there and paste it to the
> > userfom conveniently? Thank you.
> >
> > Mike
>
>
>