+ Reply to Thread
Results 1 to 5 of 5

Populate combobox with names list

  1. #1
    Forum Contributor Axmed.cm's Avatar
    Join Date
    02-05-2015
    Location
    Somalia
    MS-Off Ver
    2013
    Posts
    231

    Populate combobox with names list

    Hi all

    I have list of names in A4:A12 and combox21 in the excel.

    I want to poupulate these names in combobox21.

    if the combobox is in userfor i would use
    "private sub userform_initialize"
    combobox21.additem.............
    but if the combobox is in the sheet how do I use?

    Could anyone help me to do so??
    GUURE

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,857

    Re: Populate combobox with names list

    If it's an activeX box, right click, select properties and put the range in the listfillrange box
    Ben Van Johnson

  3. #3
    Forum Contributor Axmed.cm's Avatar
    Join Date
    02-05-2015
    Location
    Somalia
    MS-Off Ver
    2013
    Posts
    231

    Re: Populate combobox with names list

    Dear Protonleah
    it is an activeX control box in worksheet.

  4. #4
    Forum Contributor Axmed.cm's Avatar
    Join Date
    02-05-2015
    Location
    Somalia
    MS-Off Ver
    2013
    Posts
    231

    Re: Populate combobox with names list

    SOLVED,

    THank you Dear

  5. #5
    Forum Contributor Axmed.cm's Avatar
    Join Date
    02-05-2015
    Location
    Somalia
    MS-Off Ver
    2013
    Posts
    231

    Re: VPA Password problem

    Dear friend.

    Another issue.......

    I have a problem relating VBA Project password.
    After I closed excel the vba Password is in the desktop? and can't be canncelled uless to click cancell button many times.
    I need a solution for that problem.
    Thank you in advance..

+ 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 Combobox with Worksheet Names EXCLUDE hidden
    By smartbuyer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-28-2013, 11:03 PM
  2. Add combobox to a Word doc and populate the combobox with list of about 65 items
    By excelaron in forum Word Programming / VBA / Macros
    Replies: 6
    Last Post: 06-21-2012, 01:59 PM
  3. populate userform combobox with sheet names
    By tapapad in forum Excel General
    Replies: 3
    Last Post: 11-14-2008, 03:10 AM
  4. Populate combobox with Range names - xl2003
    By elcentro3m in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-16-2007, 12:06 PM
  5. Populate combobox with Range names - xl2003
    By elcentro3m in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-15-2007, 06:44 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