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,
Bookmarks