+ Reply to Thread
Results 1 to 4 of 4

Userform combobox display one of the items in list

  1. #1
    Forum Contributor
    Join Date
    08-14-2014
    Location
    US
    MS-Off Ver
    2013
    Posts
    135

    Userform combobox display one of the items in list

    Hopefully a simple one for someone. I managed to get the combobox to populate using a row of words, got it to hide all blank spots in the list. Now the part i am having an issue with I did manage to get the box to display the first item in the dropdown but I cant seem to make it work correctly so say I wanted the second item in the list to display by default I cant I only seem to get the first one. Can this be changed so I can just change a number to display a default item?

    Please Login or Register  to view this content.
    As always thank you for looking

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Userform combobox display one of the items in list

    Try setting the ListIndex.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    08-14-2014
    Location
    US
    MS-Off Ver
    2013
    Posts
    135

    Re: Userform combobox display one of the items in list

    I am struggling to learn how and where to put things honestly not sure where to input that. I replaced rheadings(1) with it replaced Me.txtAssignmentType.Value = rheadings(1) with it and added it without removing anything and I am not having any luck

  4. #4
    Forum Contributor
    Join Date
    08-14-2014
    Location
    US
    MS-Off Ver
    2013
    Posts
    135

    Re: Userform combobox display one of the items in list

    Thank you was having a problem but figure out I had to input that after the list had loaded.

+ 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. Need the Userform Combobox to display value from list only once
    By SHUTTEHFACE in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-18-2014, 04:58 PM
  2. Populating Userform ComboBox Using Items from Content Control Combobox
    By anarxo in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2014, 01:00 PM
  3. Userform Combobox - Choose Multiple Items from list and input on seperate lines
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2012, 04:09 PM
  4. 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
  5. How do I refer to the items in a combobox by their number in the list of items?
    By lottesfog in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-06-2007, 10:03 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