Displaying Userform
 

I have a "working" userform within a spreadsheet for order-entry. However, I
would like to display a "non-working" userform on another worksheet that
gives instructions on how to actually execute and run the order-entry macros.

Do I have to create a new, identical userform or is there a way to display
it on the other worksheet? It would be great if there was a way to have it
display permanently, or like a watermark.

Thanks for your help.

Les

Displaying Userform
 

You can do a print screen and paste it into another sheet. Bring up your
form on the screen so that it has the focus, then press Alt+PrtScrn go to
the blank sheet and right click, then click paste. It should paste only the
UserForm. Then you can use the drawing tool bar to make arrows, etc. and
type in text boxes for the instructions. Rots o ruck.

"WLMPilot" wrote:

I have a "working" userform within a spreadsheet for order-entry. However, I
would like to display a "non-working" userform on another worksheet that
gives instructions on how to actually execute and run the order-entry macros.

Do I have to create a new, identical userform or is there a way to display
it on the other worksheet? It would be great if there was a way to have it
display permanently, or like a watermark.

Thanks for your help.

Les