Results 1 to 5 of 5

ListBox List function not allowing column argument when assigned to a variable

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2010
    Location
    Gothenburg
    MS-Off Ver
    Excel 2003
    Posts
    50

    ListBox List function not allowing column argument when assigned to a variable

    Hello everyone

    I have a weird problem. I have a list box with 4 columns that I wish to assign/read with the List function. If I use the ListBox directly i.e.

    ListBox21.List(row, column)

    it works. But if I first assign a variable

    Set Lst = ListBox21
    Lst.List(row, column)

    it says it can't find the function, it can however find a function called list with only one argument, i.e. the index for the row.

    What am I doing wrong?

    Thanks in advance
    Last edited by Brunstgnegg; 06-24-2010 at 04:05 AM.

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