Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying a Userform | Excel Programming | |||
Userform for displaying values from a row | Excel Programming | |||
Userform not displaying correctly | Excel Programming | |||
Displaying one userform from another | Excel Programming | |||
UserForm Toolbox displaying | Excel Programming |