Load list box

**h_aesa1** · 10-06-2009, 03:34 PM

I have this piece of code that loads a list box and it has worked without 1 problem for the longest time.

Today, there have been 4 or 5 instances when it doesn't work, where I hit the load button and it does nothing.

I have closed down and restarted and it seems to work but this is very annoying....can someone please give advice or explanation as to why this is happening

below is the code I have

HTML Code:

thanks

JJ

**Leith Ross** · 10-06-2009, 05:48 PM

Hello JJ,

If possible, please post your workbook. They maybe something else that is contributing to problem. Incomplete Sub or Function procedures are of little use in troubleshooting problems.

**h_aesa1** · 10-07-2009, 10:29 AM

Hi Leith,

thanks for the response but there is no way to post the workbook.

I think I found the issue though.

Last night I was trying to search for something with Ctrl F on the Data sheet and it wouldn't find something I knew was in there. So I hit options and saw that the match entire cell contents was checked.

I tried this a couple of times and it seems I had another piece of code that was checking the match entire, so when I typed in a business name (partial) it found no records.

So I added this to the code

HTML Code:

and it seems to be working.

thanks

JJ

**royUK** · 10-07-2009, 12:28 PM

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save