• 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


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

Displaying Column Titles in List Box


New Member
Regards to you all
I am kindly seeking some enlightenment on the following scenario. The scenario is we have an Excel Sheet named Purchases. I have created a simple User form whose primary function is to facilitate the search of Purchase Receipt Nos using a text box and results are displayed in the list box. Basically what happens is that having entered the desired receipt no the user clicks the Search button and the results are displayed in the List box. The basic search procedure is working alright but column titles are not displayed though I have turned on the Column head property in my code. Is there any tweaking that I can apply to my code so that the column titles are displayed in the list box?