+ Reply to Thread
Results 1 to 5 of 5

Refresh a Userform

  1. #1
    Forum Contributor
    Join Date
    01-11-2016
    Location
    Brazil
    MS-Off Ver
    2010
    Posts
    125

    Refresh a Userform

    Hello pros,

    I need a formula that will refresh my userform, without closing it. This is because i have textboxes that are linked to a worksheet that changes values. Whenever a value is changed in the worksheet, the userform does not use the updated value.

    I already tried:

    Unload Me
    UserForm1.Show

    But this deletes everything and doesn't really work practically.. Please help!!

    Thanks!

  2. #2
    Registered User
    Join Date
    01-03-2014
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    71

    Re: Refresh a Userform

    on the control button where you send the data to the sheet put in
    Please Login or Register  to view this content.
    That should reset all your textboxes checkboxes and combo boxes to blank then will restart the form with the correct data in
    Last edited by AllenF; 02-22-2016 at 09:44 AM.

  3. #3
    Valued Forum Contributor
    Join Date
    05-14-2012
    Location
    Unknown
    MS-Off Ver
    Unseen
    Posts
    429

    Re: Refresh a Userform

    I think you'd need a Worksheet Change event handler monitoring the cells on the worksheet and, when they change, update the values on the User Form.

    Suggest you post a sample workbook with some typical data, the user form and the code.

  4. #4
    Valued Forum Contributor
    Join Date
    05-14-2012
    Location
    Unknown
    MS-Off Ver
    Unseen
    Posts
    429

    Re: Refresh a Userform

    I think you'd need a Worksheet Change event handler monitoring the cells on the worksheet and, when they change, update the values on the User Form.

    Suggest you post a sample workbook with some typical data, the user form and the code.

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Refresh a Userform

    How are the controls on the form linked to the cellscon the worksheet?
    If posting code please use code tags, see here.

+ 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] Userform refresh problem
    By Lukael in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-03-2015, 07:49 AM
  2. [SOLVED] Refresh userform when opened
    By JO505 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-27-2015, 09:32 PM
  3. Refresh Treeview on UserForm
    By zplugger in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-17-2015, 09:10 AM
  4. Identifying Cause Of UserForm Refresh
    By RowanB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-25-2013, 06:22 AM
  5. [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
  6. Userform refresh not showing
    By Alfaholic in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-27-2009, 03:06 PM
  7. 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