Closed Thread
Results 1 to 5 of 5

actionbased multi selected items in listbox

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

    actionbased multi selected items in listbox

    Guys,

    I've this code to change cells value of selected items in list box.

    Please Login or Register  to view this content.

    for this line
    Please Login or Register  to view this content.
    I dont know what is exactly the problem
    can any one help me to do an action with multi slected items in list box


    Thanks

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: actionbased multi selected items in listbox

    You want to put all items selected into the same cell?

    Be very detailed about what you're trying to do, not what you think the solution is. You would like to put all selected items in a multi-select list box where?
    Last edited by Solus Rankin; 11-15-2013 at 10:01 AM.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

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

    Re: actionbased multi selected items in listbox

    Sorry If im not detailed,

    All what I want to do, is multi select items in a list box ( I can do it by changing the property of the list box)
    and the take an action based on what is selected
    so I'm trying to change a specific range in worksheet based on this multi selection

  4. #4
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: actionbased multi selected items in listbox

    What is the specific range? Do you want each selected value in the listbox to be in a different cell?

  5. #5
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: actionbased multi selected items in listbox

    Solus Rankin

    Sorry for your time that you loose on this....but

    mido609


    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy Selected items from multicolumn, multiselect listbox to another listbox
    By Willigb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-19-2013, 11:27 AM
  2. Transfer random listbox items to new listbox and then loop through selected items
    By narrowgate88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2013, 05:58 PM
  3. [SOLVED] Find Multi Selected Items in Listbox in Range
    By Sniper in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2012, 07:53 AM
  4. 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
  5. multi select listbox, remove selected items.
    By D_Rennie in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-25-2009, 08:39 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