+ Reply to Thread
Results 1 to 2 of 2

Identifying Cause Of UserForm Refresh

  1. #1
    Registered User
    Join Date
    11-13-2009
    Location
    Cumbria
    MS-Off Ver
    Excel 2007
    Posts
    75

    Identifying Cause Of UserForm Refresh

    Hi Everyone,

    Can anyone tell me what would cause a user form to refresh other than saving a workbook or closing the userform by pressing the "x" in the top right corner? For a while I've been using a UserForm with numerous controls and happily opened and closed it using buttons without losing any changes made to the userform. I've done a bit of recoding recently which has done something to stop the user form retaining its informationv when I run a particular macro. I'm really struggling to identify what would cause this. Any hints? I'd post the macros, but there are too many. If anyone could just point me in the right direction or tell me how I pinpoint the moment at which the userform refreshes, that would be great.

    Thanks in advance,

    Rowan
    Last edited by RowanB; 09-25-2013 at 06:20 AM.

  2. #2
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Identifying Cause Of UserForm Refresh

    Hi Rowan,

    Could you provide a bit more background information?
    - which event based/triggered routines are you using
    - in which routine (if any) do you initialize the controls
    - is the user form displayed modal or not
    - if the form is not displayed modal, do you open other forms while this form is being displayed (lost focus?)
    - are the controls on the user form bound or unbound
    - any information about the events that lead up to the user form being cleared?
    If you like my contribution click the star icon!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Refresh UserForm after entering data in another userform
    By s2jrchoi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-30-2013, 10:34 AM
  2. Refresh userform periodically
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-22-2013, 03:05 PM
  3. How to refresh data in VBA userform
    By jdasp49 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-06-2012, 11:26 AM
  4. Userform refresh not showing
    By Alfaholic in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-27-2009, 03:06 PM
  5. [SOLVED] VBA+API refresh userForm
    By Greg in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-18-2006, 03:05 AM

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