+ Reply to Thread
Results 1 to 3 of 3

Listbox selection back to data source

  1. #1
    Forum Contributor
    Join Date
    02-12-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    275

    Listbox selection back to data source

    How do I track the source data back from the back from the lisbox selection

    The first column not unique values and that seems to be the column of data that is being exported.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Listbox selection back to data source

    We need to see how you are populating the listbox. The best way to do this is to attach your file. If you cannot attach your file then you need to show all code here.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    02-12-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    275

    Re: Listbox selection back to data source

    I have sorted the problem already by adding a unique usable number in the first column and setting the width to 0pts.

    But just as future reference

    The listbox is populated from an array and I would have searched for the row number on the worksheet with the values from all the columns

    Would this work??

+ 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. Replies: 2
    Last Post: 12-10-2014, 12:42 AM
  2. Help with Userform Data Source for Listbox refrerencing using full path
    By AuntyJean in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2014, 12:57 PM
  3. Link back to source data from a point in a scatter plot?
    By Riverglen in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-18-2012, 10:34 AM
  4. Make checklist from closed WB's and then save updated C'List data back to source WB
    By Lungfish in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-16-2011, 04:57 AM
  5. Multi select Listbox Items selection based on other Listbox item selection.
    By srinivassathi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2011, 05:53 AM
  6. Replies: 1
    Last Post: 05-17-2006, 04:50 PM
  7. [SOLVED] External Data Source updating on open, how to turn back on prompt.
    By kristy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-15-2005, 02:06 AM

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