Displaying Userform

G

Guest

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top