+ Reply to Thread
Results 1 to 2 of 2

Fill a listbox using a combox without a loop

  1. #1
    Registered User
    Join Date
    02-29-2016
    Location
    Israel
    MS-Off Ver
    2007
    Posts
    27

    Fill a listbox using a combox without a loop

    Hi all,

    New here and new to vba. I have scoured the forum for an answer so if it exists forgive me for the duplicate question.

    Is there a way to load a listbox by using the change event or click event on a combox without using a loop?

    I want the user to populate the listbox every time he clicks on the combox's item. The user needs to be free to perform other actions in the userform and I think a loop will keep him tied to loading values till he clicks a button to exit the loop.

    Thanks!

  2. #2
    Registered User
    Join Date
    02-29-2016
    Location
    Israel
    MS-Off Ver
    2007
    Posts
    27

    Re: Fill a listbox using a combox without a loop

    I managed to work it out.

    Listbox1.additem (myrange.value)
    Last edited by joseph.davidow; 02-29-2016 at 03:27 PM. Reason: Solved

+ 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] Loop find all matches of listbox items, display results in another listbox
    By banaanas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-29-2015, 02:56 AM
  2. Update Combox with Slicer items - getting error on Combox.listcount
    By Bigkx06 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-12-2014, 02:47 PM
  3. Having problems populating a multicolumn listbox changing Listbox column with a loop.
    By Aristizabal95 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2013, 12:41 PM
  4. [SOLVED] excel vba combox result shown in listbox
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2013, 10:23 AM
  5. 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
  6. Replies: 12
    Last Post: 08-28-2012, 07:09 AM
  7. To Fill a Listbox from other Listbox
    By kmlprtsngh in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-24-2010, 06:00 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