+ Reply to Thread
Results 1 to 4 of 4

Show Search results in userform

  1. #1
    Registered User
    Join Date
    02-21-2011
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    30

    Show Search results in userform

    Hi, I am using the file NameNo Data (2).xls‎ and it is working for my needs, but for the liofe of me I can't figure out why it will only return 6 column worth of row data. I have tried to make what I thought were the right change by adding additional entries as listed her but it stops at 6 column still. any ideeas

    Please Login or Register  to view this content.
    Moderator's Edit: Use code tags when posting code. To do so in future, select your code and click on the # icon at the top of your post window.


    Sorry, I forgot my code tag
    Last edited by StartingOut; 12-20-2012 at 08:59 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    11-15-2008
    Location
    ph
    MS-Off Ver
    2007/2010/2016
    Posts
    479

    Re: Show Search results in userform

    Hi -

    Please check your listbox property and look for ColumnCount

    Regards,
    Event
    Last edited by event21; 12-20-2012 at 09:45 AM.

  3. #3
    Registered User
    Join Date
    02-21-2011
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: Show Search results in userform

    A no brainier and I had no brain, Thank you Event21

  4. #4
    Registered User
    Join Date
    02-21-2011
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: Show Search results in userform

    Sorry folks, I know this is code related. so I am stuck, I was able to modify this code for my use in my project but I am getting a failure at this point, its as if all the line items that have ListCount with a double digit don't work I commented each line out to test and every one fails with error "could not set the list property, Invalid property value"

    Please Login or Register  to view this content.

    Please Login or Register  to view this content.

+ 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