Using the vbModeless constant on the Mac generates a parameter violation on
compile. I checked in the VBA Mac documentation and can't find any reference
to the FormShowConstants.

Thanks for the suggestion.

Bill

"Jim Rech" wrote:

Ah, the things you don't see in Mac TV commercials<g.

I suppose explicitly showing the form modeless fails too?

UserForm1.Show vbModeless

--
Jim
"Bill" wrote in message
...
| Hi Jim:
|
| Thanks for the suggestion. I tried it but it seems to work the same way
the
| Application.Wait method does; once the Show method has been invoked the
| program halts execution until the form is closed.
|
| Bill
|
| "Jim Rech" wrote:
|
| I know nothing about Excel on Macs but here's an alternate method that
works
| on PCs and may on Macs.
|
| Sub ShowUF()
| Application.OnTime DateAdd("s", 5, Now), "CloseUF"
| UserForm1.Show
| End Sub
|
| Sub CloseUF()
| Unload UserForm1
| ''Other stuff
| End Sub
|
|
| --
| Jim
| "Bill" wrote in message
| ...
| |I have created a splash screen that works fine in Windows Excel but not
on
| a
| | MacIntosh. I am using Application.wait to have the splash screen
appear
| for
| | five seconds but on the Mac it will not disappear. From my testing it
| appears
| | that on the Mac the splash screen is being treated as a modal dialog
box
| so
| | the five second timer does not start until after the user has manually
| closed
| | it. I have looked at the properites but can't see any place to set it
to
| | non-modal.
| |
| | Any suggestions on how to change this.
| |
| | TIA
| |
| | Bill
|
|
|