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

[cyberdude]

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 Strazzeri]

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

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 Robbins - Word MVP]

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]

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

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 Robbins - Word MVP]

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

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

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]

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

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

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