Results 1 to 9 of 9

How to pass user selected list items from listbox to another procedure in excel using vba

Threaded View

mahendra.asapu How to pass user selected... 04-14-2016, 01:40 AM
6StringJazzer Re: How to pass user selected... 04-14-2016, 09:02 AM
mahendra.asapu Re: How to pass user selected... 04-14-2016, 09:35 AM
mahendra.asapu Re: How to pass user selected... 04-14-2016, 09:56 AM
mahendra.asapu Re: How to pass user selected... 04-14-2016, 09:53 AM
mikerickson Re: How to pass user selected... 04-14-2016, 11:30 PM
mahendra.asapu Re: How to pass user selected... 04-18-2016, 11:26 PM
Norie Re: How to pass user selected... 04-19-2016, 12:27 AM
mahendra.asapu Re: How to pass user selected... 04-20-2016, 03:51 PM
  1. #1
    Registered User
    Join Date
    02-23-2014
    Location
    Seattle
    MS-Off Ver
    Excel 2010
    Posts
    60

    How to pass user selected list items from listbox to another procedure in excel using vba

    Hello Excel Forum members,

    Greetings!

    I have one scenario where I need some guideline based on your expertise

    How do I pass list of items that are selected from a list box Critical-High Issues, UTT ISSUES, BTT ISSUES
    (the list includes worksheet tabs with specific names, for example Critical-High Issues, UTT ISSUES, BTT ISSUES etc..)

    when user clicked on a command button(Include) in userform(usrFrmemail) the selected only list items(if I select Critical-High Issues, UTT ISSUES as list items whichare required to pass to proc in other module.

    I have a module based procedure where I am preparing a dynamic workbook with subset of tabs (few tabs / all tabs) such as selected tabs from listbox.

    In a module I have following line of code where a new sub workbook is prepared dynamically but dependent on passed selected list items.

    Please let me know, any help is appreciated.
    attaching the template for reference on source code.

    Regards,
    Mahendra
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Listbox Multiple Selected Items
    By rain4uu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-16-2014, 02:08 AM
  2. [SOLVED] Add Selected Items From One ListBox to Another ListBox on UserForm
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-27-2014, 06:53 PM
  3. 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
  4. 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
  5. [SOLVED] How to use selected items from Listbox
    By gerard.kompier@shell.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2006, 11:10 AM
  6. ListBox Selected Items into an Array
    By jtp550 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-27-2005, 07:44 PM
  7. Select multiple listbox items and pass to an array
    By golzilla in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2005, 05:49 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