+ Reply to Thread
Results 1 to 4 of 4

Add multiple items to multiple comboboxes - UserForm

  1. #1
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Add multiple items to multiple comboboxes - UserForm

    Hi,

    I hope someone can help me with this
    I'm trying to add values found on a sheet to multiple comboboxes on a userform and I'm stuck.
    Can someone please help me with this?
    All the comboboxes are in frame "frameP"

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Add multiple items to multiple comboboxes - UserForm

    Please Login or Register  to view this content.
    (Outer loops ignored for brevity - these don't change)

    You don't include code to clear the comboxes before adding. Intentional?
    Last edited by cytop; 07-07-2017 at 06:11 AM.

  3. #3
    Forum Contributor stojko89's Avatar
    Join Date
    05-18-2009
    Location
    Maribor, Slovenia
    MS-Off Ver
    MS Office 365
    Posts
    913

    Re: Add multiple items to multiple comboboxes - UserForm

    Thank you very much for this!
    Didn't know it had to be dim as control instead of combobox

    BR, Denis

  4. #4
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Add multiple items to multiple comboboxes - UserForm

    There is no collection made up of just Comboxes but there is of Controls. So you loop the collection of Controls checking if each member is the type you want to process.

+ 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] Dynamic vendor contact userform with multiple comboboxes
    By yohanmcdonald in forum Excel General
    Replies: 1
    Last Post: 02-03-2015, 11:56 AM
  2. Multipying Multiple ComboBoxes on a Vba userform
    By smurfdjman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2013, 06:52 PM
  3. Set multiple comboboxes rowsource equal to the same multiple ranges
    By thorn29 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2013, 01:05 AM
  4. [SOLVED] Multiple comboboxes populated with same lists; data entered to multiple rows.
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2012, 01:34 PM
  5. [SOLVED] Multiple dynamic Comboboxes in UserForm
    By joehjas in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-17-2012, 03:43 AM
  6. Adding information from multiple ComboBoxes in a UserForm (Looping?)
    By H0NKEN in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-08-2012, 03:23 AM
  7. UserForm with Multiple ComboBoxes Populate
    By RobertCo in forum Excel General
    Replies: 2
    Last Post: 12-27-2006, 01:51 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