+ Reply to Thread
Results 1 to 3 of 3

Userform submit button to load listbox1 and listbox2 selection to same cell

  1. #1
    Registered User
    Join Date
    07-28-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    13

    Userform submit button to load listbox1 and listbox2 selection to same cell

    Hello everyone!

    Have a bit of trouble working out a very simple issue today. I have a userform with a submit button that I need to pull single selection from listbox1 and the single selection from listbox2 and list it those selections in a single cell (sheet1) separated by a comma. Any help on this would be most helpful, before I pull my hair out.

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Userform submit button to load listbox1 and listbox2 selection to same cell

    Assuming the single cell is A1:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-28-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Userform submit button to load listbox1 and listbox2 selection to same cell

    That worked perfectly! Thank you for your help on this.

+ 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] Populate Listbox2 based on Listbox1 selection
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2013, 09:04 AM
  2. [SOLVED] ListBox2 selection must be based on ListBox1 selection
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2013, 12:23 PM
  3. Populate Listbox2 from Listbox1 selection
    By Macro1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2010, 07:06 AM
  4. [SOLVED] ListBox2.AddItem ListBox1.Value becomes a String when being Integer?
    By SIGE in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2005, 12:06 PM
  5. Listbox1 to Listbox2?
    By Moretakitty in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 01-20-2005, 07:06 PM

Tags for this Thread

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