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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cyberdude - 30 Mar 2008 03:23 GMT

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

Reply to this Message

Tony Strazzeri - 30 Mar 2008 03:53 GMT

> Hi,
>
[quoted text clipped - 7 lines]
>
> 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.

Reply to this Message

Doug Robbins - Word MVP - 30 Mar 2008 03:55 GMT

Use

[formobject].Show Modal

Signature

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,
>
[quoted text clipped - 7 lines]
>
> Mike

Reply to this Message

cyberdude - 30 Mar 2008 05:05 GMT

On 3月30日, 上午10時55分, "Doug Robbins - Word MVP"
<d...@REMOVECAPSmvps.org> wrote:

> Use
>
[quoted text clipped - 21 lines]
>
> - 顯示被引用文字 -

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

Reply to this Message

Doug Robbins - Word MVP - 30 Mar 2008 09:52 GMT

You will have to be content with using Ctrl+V

Signature

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

> On 3$B7n(B30$BF|(B, $B>e8a(B10$B;~(B55$BJ,(B, "Doug Robbins - Word MVP"
> <d...@REMOVECAPSmvps.org> wrote:
[quoted text clipped - 40 lines]
>
> Mike

Reply to this Message

Rate this thread: