+ Reply to Thread
Results 1 to 2 of 2

ISSUE: Using the multi selection in list box to change cells in worksheet.

  1. #1
    Registered User
    Join Date
    03-23-2011
    Location
    Egypt
    MS-Off Ver
    Excel 2007
    Posts
    30

    ISSUE: Using the multi selection in list box to change cells in worksheet.

    All,

    I've attached exactly what I need to avoid any confusion"

    Please
    1- what I need is to open the usef form by clicking start
    2- and then multi select items from the listbox
    3-then reflect the value in the combo box to be listed in column B for the selected items in listbox

    for the moderaters sorry for you considered this as a duplicated subject but it is a different example and really i'm facing this problem since 2 days.


    Thanks for you ALL and this nice forum
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: ISSUE: Using the multi selection in list box to change cells in worksheet.

    Hi

    I find your code is overcomplicated, so I think you need some help.

    I have created a new userform2 for you to show you how it should be done.

    My code for what you describe follows:-

    Please Login or Register  to view this content.

    Because I am using an array there is only one read and one write from excel to VBA.

    The listbox property Multiselect is set to multiselectmulti
    Attached Files Attached Files
    Last edited by mehmetcik; 11-17-2013 at 08:42 PM.

+ 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: 1
    Last Post: 04-12-2013, 06:27 PM
  2. Multi selection list box
    By pickledmuffin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-04-2008, 04:28 AM
  3. list box - how does multi selection work?
    By arunjoshi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-17-2005, 09:49 AM
  4. copying results from multi selection list boxes to cells
    By Panos in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-03-2005, 10:06 AM
  5. Multi Selection List?
    By HotRod in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-31-2005, 05:06 PM

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