+ Reply to Thread
Results 1 to 2 of 2

Can't make listbox with multi select transfer to excel cell with comma's between selection

  1. #1
    Registered User
    Join Date
    05-22-2018
    Location
    North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    1

    Question Can't make listbox with multi select transfer to excel cell with comma's between selection

    I'm really new to VBA and have been teaching myself over the last week. I'm trying to make this userform simple for the people that I work with as they are not computer literate but I am stuck on this listbox and making it transfer the selected items to the cell.

    Any help is appreciated.

    This is the code I have for the text box itself:
    Please Login or Register  to view this content.
    and this is the code I'm trying to use on the command add button:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by hweston; 05-23-2018 at 08:10 AM.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Can't make listbox with multi select transfer to excel cell with comma's between selec

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. [SOLVED] Userform Multi-Select Listbox Selection Condition to unhide Frame and controls
    By pjbassdc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2016, 10:05 AM
  2. pop-up multi-selection listbox
    By capson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-08-2016, 06:10 PM
  3. [SOLVED] Unhide 2nd Listbox when condition is met in the 1st multi-select listbox
    By pjbassdc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2015, 09:58 AM
  4. Replies: 4
    Last Post: 05-09-2013, 03:56 AM
  5. [SOLVED] Multi Select ListBox with Multicolumns - if row is empty do not transfer
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2013, 09:01 PM
  6. [SOLVED] Multicolumn Listbox selection transfer to cell
    By audiotunesx in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-14-2012, 08:16 PM
  7. 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

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