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

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

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
>