Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Command Button on User form for Printing
Hi
I have a developed a user form with a lot of help from this site but now I need some more help. I have a Command Button that upon clicking, prints out the requested information. Before actually printing, I would like a 'splash screen' to pop up with a small message. This message needs to be displayed for a few seconds then disappears before continuing with printing. Any help would be appreciated |
#2
|
|||
|
|||
You could add a line like:
CreateObject("WScript.Shell").Popup "Hello", 4, _ "This closes itself in 4 seconds" to your code. Anthony Slater wrote: Hi I have a developed a user form with a lot of help from this site but now I need some more help. I have a Command Button that upon clicking, prints out the requested information. Before actually printing, I would like a 'splash screen' to pop up with a small message. This message needs to be displayed for a few seconds then disappears before continuing with printing. Any help would be appreciated -- Dave Peterson |
#3
|
|||
|
|||
Thanks Dave
That really helped... "Dave Peterson" wrote: You could add a line like: CreateObject("WScript.Shell").Popup "Hello", 4, _ "This closes itself in 4 seconds" to your code. Anthony Slater wrote: Hi I have a developed a user form with a lot of help from this site but now I need some more help. I have a Command Button that upon clicking, prints out the requested information. Before actually printing, I would like a 'splash screen' to pop up with a small message. This message needs to be displayed for a few seconds then disappears before continuing with printing. Any help would be appreciated -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use a text box to calculate and show results in a user form | Excel Discussion (Misc queries) | |||
Print scrollable user form. | Excel Discussion (Misc queries) | |||
user form | Excel Discussion (Misc queries) | |||
Data Entry Alert in User Form | Excel Discussion (Misc queries) | |||
A "previous" button on a user form | Excel Discussion (Misc queries) |