Range.find returns "Nothing" in error, not sure of cause

[enphynity]

So I have a userform with some listboxes, textboxes and frames on it (most of the textboxes are inside of frames). One listbox is populated with claim information and when a claim is selected, a range.find is used to locate the specific claim in a large EDI file. Once the claim is found, the textboxes are populated with various data regarding the claim. I also have a frame.click event set up so that when a person clicks on a specific frame a function is called that causes a message box to pop up with additional info for the claim.

The problem I am running into is that once the frame is clicked and the message box comes up, clicking the listbox with claims on it causes the range.find to return "Nothing" even though it should not. If I were to click the listbox again without bringing up the message box, everything works fine. But when the message box is shown, it causes the range.find to malfunction and I have yet to be able to pinpoint the problem. They do not use same name variables. I had originally used a class module to produce the message box and thought that was the issue but after removing it the problem persists.

Code for finding claim in EDI file

Please Login or Register  to view this content.

Code in module to show message box

Please Login or Register  to view this content.

[Norie]

The first code never calls MoreInfo or displays a message box.

Also, there's not check in it for Find returning Nothing.

[enphynity]

The first code isn't meant to call the function, it's just there to show where the error occurs.

The point is that the range.find should not return "Nothing" as I have checked the data and it should definitely find something. If I replicate steps without bringing up the message box, the error does not occur.

[Norie]

Have you stepped through the code checking all variables/values?

By the way, what error are you referring to here?

Please Login or Register  to view this content.

[enphynity]

ptnRange ends up equaling "Nothing", which in turn causes the next line of code to give the "Object variable or With block variable not set". I have stepped thru multiple times and can find no variable overlap.

Another thing worth noting, if I click on another listbox that is on the form which refreshes the listbox with the claims, then the code works. Could it have something to do with the claim listbox losing focus or needing to be refreshed?

[Norie]

Ah, so the error is on the next line.

Have you checked all the values?

For example Remit.Claim_list.List(x, 6)?

Also, have you tried the Find with all the arguments?

If you omit arguments then the settings used can be those of the last Find operation.

[enphynity]

So I changed

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and it's working now! I guess one of those arguments was important haha.

Thanks for the help and problem solving suggestion!