Improve VBA search

[janagan]

Hi Friends,

I have a problem with excel VBA, please advice me how to modify the codes as efficient.

1 worksheet is customer settlement database. I have 4000 customer records.

When I enter customer number I could get specific row of data such as Date of settle, Amount settled, etc.

Extracted code is as follow.

Please Login or Register  to view this content.

This code work perfectly. But the problem is when I press button, every time it goes 4000, 5000 row of data. My problem is it takes more time to compile. Is there any efficient way to handle it? please help me. Every time when i press button it should check all 4000 row of records, because 1 customer settle different amount in different dates. Thanks

[AB33]

You have lots of select in your code and these slow down the code. Please attach a sample book. Go to advance then attachment.