• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cannot figure out

Artisez

Artisez

Member
I have a phone list that I am trying to display results in a listbox. However every time I attempt to have the headers displayed in the listbox the textbox search stops working. I cannot figure it out, any help would be appreciated
 

Attachments

Hi ,

Can you explain the exact sequence of steps we should take to reproduce the problem at our end ?

I am not clear on what the problem is.

Narayan
 
To show my headers under the list box properties for row source I add my list name "myheader". The headers will display in the list box. However the search function for the text box will not work. Remove the row source and the search function will work.
 
The Ucase seems to be limiting the search results. It will list the results only for the first letter entered and only if upper case. The header is displaying in the list box which is very nice. I will look into the upper case and lower issue. THANKS!, I appreciate your help and time.
 
Hi ,

It will list the results only for the first letter entered
Click to expand...
This is because the code was already using the LEFT function to compare.

If you wish to list data if it contains the search text anywhere within the data , you will have to use a different method , as in :

If Sheet_cell_contents Like "*" & Textbox_contents & "*" Then

Narayan
 
You must log in or register to reply here.
Back
Top