+ Reply to Thread
Results 1 to 3 of 3

Application.Ontime running behind a UserForm

  1. #1
    Registered User
    Join Date
    08-24-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    37

    Application.Ontime running behind a UserForm

    Hi all,

    I have a problem when trying to use a UserForm alongside a Macro that updates every n seconds.

    My Macro uses the Application.OnTime function to run every 3 seconds. Whilst it is doing this I want to have a UserForm open for me to input values that are used elsewhere within my program. Trouble is whenever the UserForm is open my Macro stops running in the background until I close the userForm, and then it starts running again. I want to have the form constantly open as I'll be inputting data into the program as it runs. Is there a simple way to do this?

    Thanks,

    W

  2. #2
    Registered User
    Join Date
    08-24-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: Application.Ontime running behind a UserForm

    EDIT.

    post deleted
    Last edited by Walter12; 10-11-2012 at 01:45 PM. Reason: wrong thread title

  3. #3
    Registered User
    Join Date
    08-24-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: Application.Ontime running behind a UserForm

    OK, So I think the issue here is not necessarily native to Application.OnTime, but rather Macros not running when a userform is open.
    If i could change the title of this thread it might make more sense, so I suppose the question is can a UserForm be open and editable while other Macros are running?

+ Reply to Thread

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