Cylce through search results in a UserForm VBA

Hi all,

I am creating a UserForm that performs search and Replace type functions. I search the document by a Project ID and the results are populated into the UserForm. Here is the issue I am having. I have multiple data per ProjectID and I want to be able to cycle through the entries by using a next button.

The code I have below works but only for the first entry. Any suggestions you might have for going about this would be greatly appreciated!

Please Login or Register  to view this content.

Originally Posted by Norie

Why not display the results in a listbox?

Brilliant. I have never used one. How do I make it?