+ Reply to Thread
Results 1 to 3 of 3

Fill Combobox

  1. #1
    Registered User
    Join Date
    08-08-2009
    Location
    kilkenny,ireland
    MS-Off Ver
    Excel 2010
    Posts
    55

    Fill Combobox

    Hello,

    I am hoping someone might explain to me why this keeps erroring.

    I want to fill the combobox with column B sheet2 when the userform is activated.

    but it just errors each time i press the button.

    Take a look at attached.

    Any advice would be great.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-11-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    232

    Re: Fill Combobox

    Would a listbox work better for what you want, or are you going to be selecting from that list later?

  3. #3
    Registered User
    Join Date
    08-08-2009
    Location
    kilkenny,ireland
    MS-Off Ver
    Excel 2010
    Posts
    55

    Re: Fill Combobox

    Hello Nemo74,

    No they want the combobox.

    I just can't understand why it's erroring at index = index + 1
    since i have index initiated to 4 at the start.

    it should just go to index = 5,6,7 etc
    and load the names into the combo box.
    Last edited by giant; 04-26-2013 at 04:08 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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