Results 1 to 3 of 3

Imported UserForm runs slowly

Threaded View

pnmng49 Imported UserForm runs slowly 09-03-2011, 08:01 AM
royUK Re: Imported UserForm runs... 09-03-2011, 09:41 AM
pnmng49 Re: Imported UserForm runs... 09-03-2011, 10:39 AM
  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.

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