+ Reply to Thread
Results 1 to 4 of 4

Set a default value for a combobox

  1. #1
    Forum Contributor
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    100

    Set a default value for a combobox

    Hi,

    I used the codes in this website to create a multi level dependent drop-down comboboxes in userform. (I didn't use the sub-item)

    http://www.pk-anexcelexpert.com/vba-...-in-user-form/

    how can I set a default value for only the first combobox?
    (category-3 should be the default value, as the userform is opened) and the subcategory and item should be empty

  2. #2
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,134

    Re: Set a default value for a combobox

    In UserForm_Activate procedure, add this line;

    Please Login or Register  to view this content.
    after;

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    100

    Re: Set a default value for a combobox

    Thank you

  4. #4
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,134

    Re: Set a default value for a combobox

    You're welcome...

+ 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. ComboBox default option
    By plans in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-05-2017, 03:54 PM
  2. [SOLVED] How can I default populate my Combobox?
    By bralew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-14-2016, 07:06 AM
  3. [SOLVED] Change default Combobox value
    By ABSTRAKTUS in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-10-2015, 08:57 AM
  4. [SOLVED] Combobox Default values
    By Tortus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2014, 02:57 PM
  5. Set a value from a combobox as default.
    By Lucky555 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2010, 09:59 PM
  6. Show ComboBox default value
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-15-2009, 01:23 PM
  7. Default Value in Combobox
    By VitoHGrind in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-11-2007, 01:04 PM

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