+ Reply to Thread
Results 1 to 6 of 6

How to make the combobox appear first automatically as soon as you open the user form

  1. #1
    Registered User
    Join Date
    10-16-2021
    Location
    egypt
    MS-Off Ver
    2016
    Posts
    75

    How to make the combobox appear first automatically as soon as you open the user form

    How to make the combobox appear first automatically as soon as you open the user form

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,304

    Re: How to make the combobox appear first automatically as soon as you open the user form

    ?? a little more detail please - do you just want a loaded combobox on the form as the form appears ???
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

  3. #3
    Registered User
    Join Date
    10-16-2021
    Location
    egypt
    MS-Off Ver
    2016
    Posts
    75

    Re: How to make the combobox appear first automatically as soon as you open the user form

    I want when I open the user form, the combobox will automatically appear as the first choice
    Attached Images Attached Images
    Last edited by saftawy1; 10-28-2021 at 11:09 AM.

  4. #4
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,304

    Re: How to make the combobox appear first automatically as soon as you open the user form

    Something like the attached file ??
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-16-2021
    Location
    egypt
    MS-Off Ver
    2016
    Posts
    75

    Re: How to make the combobox appear first automatically as soon as you open the user form

    yes but i want the choice from the field or row source for combobox not text appear
    Attached Images Attached Images

  6. #6
    Registered User
    Join Date
    10-16-2021
    Location
    egypt
    MS-Off Ver
    2016
    Posts
    75

    Re: How to make the combobox appear first automatically as soon as you open the user form

    I came up with the solution, which is to choose the option I want from within the userform design by opening the combobox arrow and selecting it, then save the user form
    thank you very much

+ 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. Open files choosing path in combobox and files in checkbox (user form)
    By Nastya621 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2020, 11:32 AM
  2. VBA code to open a user form if the user form is located in an addin?
    By bresman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-19-2019, 09:04 AM
  3. [SOLVED] Difficulty using Combobox to open another window/user form
    By bralew in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-14-2016, 08:39 AM
  4. Replies: 1
    Last Post: 11-07-2014, 01:21 PM
  5. [SOLVED] Excel vba user form- open directly to user form not worksheet
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 04-24-2013, 05:07 PM
  6. make user form stay open while going to other pages but hide when i go to other sheet
    By excelslizzard in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-18-2012, 07:12 PM
  7. transferring combobox value from one user form to populate combobox on another
    By smartphreak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2010, 10:12 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