+ Reply to Thread
Results 1 to 3 of 3

ListBox Problem

  1. #1
    Registered User
    Join Date
    07-29-2008
    Location
    UK
    Posts
    2

    ListBox Problem

    Hi

    I am trying to create a ListBox that displays the results of a search from a results sheet. The user can then select the set of results to view and these are displayed on a form that can be printed, e-mailed, etc.

    To do this the entire row of each search result is copied and then pasted into the next blank row in a blank section of Sheet 1 and this is then used as the row source for the list box. I use 5 columns in the ListBox and have the ControlSource linked to cell Q38 on Sheet1. The ListBox is set to single select.

    The problem is when I set the BoundColumn = 1 (as I require the report number as the Lookup_value in a VLookUp formula) the ListBox will not select the entry. This can sometimes work (especially is I reboot the computer) but most of the time I just get a dotted box around the selected entry (instead of the entry all going blue) and the selection radio button does not select.

    If I change the BoundColumn = 2 to 5 then it works properly, but it will not work if I change it back to 1???

    I must admit that it looks as though something is running or looping somewhere but I cannot see where and don't understand why it works ok with the other boundcolumns.

    I am quite new to Excel Vb and I use the internet copy/ paste method of writing so appologies for obvious errors....

    Thanks

    John

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Jl9r,

    That's a very unusual problem. Have you tried creating a new workbook and adding the same type of control and code to it? This will help identify if the problem is in Excel or just in the original workbook.

    Sincerely,
    Leith Ross

  3. #3
    Registered User
    Join Date
    07-29-2008
    Location
    UK
    Posts
    2
    Thanks for your reply Leith - I was heading that way but somehow (and sorry but don't know why) I appear to have fixed it?!?

    John

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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