Displaying Userform

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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

Back
Top