+ Reply to Thread
Results 1 to 5 of 5

Problems with listbox display and search button with the userform

  1. #1
    Registered User
    Join Date
    04-29-2017
    Location
    Hambanthota
    MS-Off Ver
    2013
    Posts
    3

    Problems with listbox display and search button with the userform

    Hi excelforums,
    I have been using a template to suit my needs which is made by merkez. The problem might be stemming from the fact that the template had only 12 columns in listbox and I have expanded them upto 32 changing a lot. In doing so I have run into a few issues regarding listbox display and search functions.
    The issues are:
    1. When you click on Full Listbox command button. Even though the listbox displays all the rows, the same is not correctly displayed in the textboxes img1.JPG.
    The value of a column has gone missing. I believe it happens here :
    Please Login or Register  to view this content.
    2. The search button doesn’t seem to work with only the name provided. Initially only the firstname search would work. I made a few changes so that even if the full name(with spaces) is added into the search box,it should search it. But now the combobox used to select name doesn’t display. Since then I don’t get any of the search results.
    3. The final problem I am facing is that, the listbox displayed in the userform doesn’t show any titles in the first row.img2.JPG.
    This used to be displayed initially, but I had then added import workbook button to the userform (which I have now removed because it didn’t preserve the format of the importing workbook); afterwhich the title bar looks empty. How can I have the title bar display the titles again?

    Any help regarding this would be appreciated. Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Problems with listbox display and search button with the userform

    Which column is missing from the data in the textboxes?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    04-29-2017
    Location
    Hambanthota
    MS-Off Ver
    2013
    Posts
    3

    Re: Problems with listbox display and search button with the userform

    Number of studies/projects for maths is the column that has been replaced by Biology exp. And all the columns following that have replaced the previous textboxes.

  4. #4
    Registered User
    Join Date
    04-29-2017
    Location
    Hambanthota
    MS-Off Ver
    2013
    Posts
    3

    Re: Problems with listbox display and search button with the userform

    Would anyone be able to help me with this?

  5. #5
    Registered User
    Join Date
    03-09-2017
    Location
    Monrovia
    MS-Off Ver
    2013
    Posts
    57

    Re: Problems with listbox display and search button with the userform

    Try decreasing the value of a in listbox.
    Please Login or Register  to view this content.
    and so on..
    I don't know about search..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Userform to search worksheet and display data back to the userform
    By zip247 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2015, 05:46 AM
  2. Search Multiple Worksheets using a Userform and display in listbox.
    By nathandavies in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 11-18-2014, 10:22 AM
  3. [SOLVED] Search and display results to listbox
    By khhoa in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-17-2014, 05:05 AM
  4. Userform Search ListBox
    By z-eighty2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2013, 06:02 AM
  5. [SOLVED] Userform Search and Display rows in ListBox
    By Nu2Java in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2012, 10:15 PM
  6. Display a UserForm based on Data selected in another UserForm's ListBox
    By RPhilbin83 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-26-2011, 11:35 AM
  7. [SOLVED] UserForms:listbox display problems
    By Emilie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2005, 01:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1