+ Reply to Thread
Results 1 to 2 of 2

Userform Combobox - select from list, store this as default each time userform loads

  1. #1
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    423

    Userform Combobox - select from list, store this as default each time userform loads

    I have a combobox in a userform, populate the list using "rowsource" in the properties. What I want to do is store the selected value, which will then be the default value when the userform loads again. I am trying this, which I think works, unless someone has a better method? My other small problem is to clear the cells on the form, otherwise I get more than one cell being filled in, as I only one one of the choices to be input on sheet2.
    Please Login or Register  to view this content.
    then in workbook open event I have this...
    Please Login or Register  to view this content.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,584

    Re: Userform Combobox - select from list, store this as default each time userform loads

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

+ 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] Make combobox list options dependant on selection in another combobox within a userform
    By Vladimir_Dobvchenko in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-23-2013, 05:30 AM
  2. Replies: 4
    Last Post: 09-10-2013, 02:11 PM
  3. [SOLVED] Excel Userform: Populate other controls (i.e. textbox & combobox) based on combobox select
    By MileHigh_PhD in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2013, 04:50 PM
  4. ComboBox to select UserForm
    By sgp in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-12-2011, 05:08 AM
  5. Using a combobox to select sheet where data is to be copied from a userform
    By Ceeseven in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-06-2009, 02:09 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