Do I use a loop? If so, which one do I use?

[s2jrchoi]

All,

I am trying to find a more efficient and smart way to load values from a database to my userform when it initializes. I am currently using a For loop. Here is my code below:

Please Login or Register  to view this content.

How can I make this more efficient? The problem is the user might only have 3 rows of data (ID2, ID3, and ID4) but this for loop goes through all 7 rows of data to see if the If condition is true or not. I am not very good with VBA or programming as you can tell by my code. Please let me know if there are other ways of doing this.

Thank you for your help.

J

[Leith Ross]

Hello s2jrchoi,

ID2, ID3, and ID4 are not rows but cell data. You can not control what goes into to the cells which means you have to check each and every one for a possible match.

[PCI]

Perhaps not more efficient but different

Please Login or Register  to view this content.

[s2jrchoi]

Thank you Leith and Ross.

Ross - Thank you so much for your input. I think that is the best approach. Will mark this as solved!

J