Results 1 to 11 of 11

Userform: ComboBox Automatically Populating

Threaded View

  1. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Userform: ComboBox Automatically Populating

    I'd be tempted to hold the scope in a separate sheet and load the contents into the combo box when loading, this makes it easy to add additional scopes:

    so if your list was in column A in Sheet2
    ContextOfUseComboBox.List = Sheet2.Range("A1").CurrentRegion.Value
    New scopes could then be added as below:
    Sheet2.Range("A1").End(xlDown).Offset(1, 0).Value = me.ContextOfUseComboBox.Text
    Last edited by Kyle123; 10-14-2011 at 08:31 AM.

Thread Information

Users Browsing this Thread

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

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