Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Anthony Slater
 
Posts: n/a
Default 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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
Anthony Slater
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use a text box to calculate and show results in a user form stockpick Excel Discussion (Misc queries) 6 August 6th 05 06:04 AM
Print scrollable user form. cparsons Excel Discussion (Misc queries) 2 August 4th 05 04:45 PM
user form static69 Excel Discussion (Misc queries) 1 February 6th 05 08:43 PM
Data Entry Alert in User Form Kev Excel Discussion (Misc queries) 6 January 8th 05 03:01 PM
A "previous" button on a user form Anthony Slater Excel Discussion (Misc queries) 3 November 29th 04 05:57 PM


All times are GMT +1. The time now is 02:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"