+ Reply to Thread
Results 1 to 3 of 3

concatenate listbox results in textbox

  1. 04-26-2012, 09:42 AM #1
    rickdaw
    rickdaw is offline
    Registered User
    Join Date
    04-26-2012
    Location
    Calgary
    MS-Off Ver
    Excel 2003
    Posts
    5

    concatenate listbox results in textbox

    Hi, I would like to concatenate all values the user selects from column 2 of listbox1 in textbox1. This needs to be done in the order they are selected.
    Is this possible?
    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-26-2012, 10:05 AM #2
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,485

    Re: concatenate listbox results in textbox

    try this, although it will screw up if you drag the mouse down the list whilst hold the button down.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  3. 04-26-2012, 05:46 PM #3
    rickdaw
    rickdaw is offline
    Registered User
    Join Date
    04-26-2012
    Location
    Calgary
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: concatenate listbox results in textbox

    Beautiful, thanks a lot.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1