Results 1 to 5 of 5

vbModeless form problem?

Threaded View

  1. #1
    Registered User
    Join Date
    08-12-2011
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2010
    Posts
    20

    Question vbModeless form problem?

    Hello -

    I feel like this should be a relatively easy fix. I am trying to show a quick and dirty form (which simply says "please wait...") when a user clicks a button. The particular macro I'm working with takes about 3-4 seconds to run. I tried to figure this out using a Google search, but I'm not having any luck. The code I have now is:

    frmPleaseWait.Show vbModeless
    
    < all my other code is here>
    
    Unload frmPleaseWait
    I am using vbModeless because I want the rest of my code to execute in the background of this form being displayed so the user doesn't have to click anything to allow the code to continue. The form comes up entire white on my screen though, and it should have a grey background with the text "Please wait..."

    Thoughts? Ideas? Am I doing something wrong?
    Last edited by tom_19; 08-25-2011 at 04:28 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1