LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 51
Default Spash screen on a Mac?

I can't get the timeout to work on the Mac.

To get around, I used conditional compiling with #IF so if the system
detects a Mac OS, it will expand the splash form to show a "Continue"
button that the user can press to continue. On the PC, I can show the
form modeless and just unload the form after waiting. See code
below...

If anyone has ideas on how to get a timeout to work on the Mac let me
know!

Thanks!

John

Here's a snippet:

#If Win32 Then
frmSplash.Height = 82
frmSplash.Show vbModeless
Wait 3 ' Wait 3 seconds (WAIT is a small custom sub to wait
designated number of secs)
Unload frmSplash
' automatic time out
#ElseIf Mac Then
frmSplash.Height = 105 ' Expand form to show "Continue" button
which unloads the form when pressed
frmSplash.Show
' Need separate mac processing to allow user to hit OK button
' since mac's can't show form modeless
#End If




 
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
Inputbox Location on Screen. Can you code it to popup lower on the screen ? Corey Excel Programming 3 December 13th 06 11:33 PM
print box opens in right screen of dual screen setup why gerrys Excel Discussion (Misc queries) 1 June 30th 06 06:47 PM
Need to convert point on screen to various screen resolutions Donna YaWanna Excel Discussion (Misc queries) 5 October 26th 05 10:10 PM
Need to convert point on screen to various screen resolutions Donna YaWanna Excel Programming 5 October 26th 05 10:10 PM
How to copy data from excel to power point screen by screen? luvgreen[_3_] Excel Programming 0 April 9th 04 03:51 PM


All times are GMT +1. The time now is 09:44 AM.

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

About Us

"It's about Microsoft Excel"