+ Reply to Thread
Results 1 to 3 of 3

Imported UserForm runs slowly

  1. #1
    Registered User
    Join Date
    09-03-2011
    Location
    Texas, USA
    MS-Off Ver
    Excel 2007
    Posts
    22

    Imported UserForm runs slowly

    Good morning everyone,

    Excel vba newbie needs some help, please.
    I have a User Form which worked fine(ran fast) in a test data file. After importing this User Form to the real file it runs painfully slowly.
    The User Form uses the Range.Find method to locate a record based on value in Col A, then uses an offset scheme to display values currently stored in the cells, and the gives the user an opportunity to change a cell value (Cells(uRow, 1).Value = OrgIDNew.Value) and save as an updated record.
    As I said, this update process runs very slowly after importing. The only difference in the structure of the two files that I can think of is that the real file has some Data Validation applied to some columns. Is this what is causing the User Form to perform slowly? or do I need to find something else?
    I have attached all the User Form code as a text file. Any input is greatly appreciated.

    Thanks,
    Attached Files Attached Files
    Last edited by pnmng49; 09-03-2011 at 10:37 AM. Reason: I have attached a sample workbook.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Imported UserForm runs slowly

    Try attaching the workbook.

    I don't e why you need to clear the userform before closing, this will happen anyway
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    09-03-2011
    Location
    Texas, USA
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Imported UserForm runs slowly

    Thanks for the reply, RoyUK.

    I have attached a sample workbook which is now attached to my original posting. Hope you can help.

    Thanks,

+ 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