+ Reply to Thread
Results 1 to 12 of 12

Combobox on Userform not saving selection when form is closed

  1. 07-01-2014, 11:41 AM #1
    guitarsweety
    guitarsweety is offline
    Forum Contributor guitarsweety's Avatar
    Join Date
    10-30-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2010
    Posts
    188

    Combobox on Userform not saving selection when form is closed

    I have ComboBox on a Userform, but when I make the selection, close the Userform and re-open it the selection I made is no longer there. Can anyone tell me what I'm doing wrong?
    Reply With QuoteRegister To Reply
  2. 07-01-2014, 11:42 AM #2
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Combobox on Userform not saving selection when form is closed

    You need to store the selection somewhere and reinstate it when you re-open the userform.

    Or you could just hide the userform, but that might not be ideal.
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  3. 07-01-2014, 01:09 PM #3
    guitarsweety
    guitarsweety is offline
    Forum Contributor guitarsweety's Avatar
    Join Date
    10-30-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2010
    Posts
    188

    Re: Combobox on Userform not saving selection when form is closed

    The only problem is when I set the control source property, it changes the data to decimals. See Images:Attachment 329227Attachment 329227
    Reply With QuoteRegister To Reply
  4. 07-01-2014, 01:15 PM #4
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Combobox on Userform not saving selection when form is closed

    How are you populating the combobox?
    Reply With QuoteRegister To Reply
  5. 07-01-2014, 01:17 PM #5
    guitarsweety
    guitarsweety is offline
    Forum Contributor guitarsweety's Avatar
    Join Date
    10-30-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2010
    Posts
    188

    Re: Combobox on Userform not saving selection when form is closed

    On UserForm_Initialize

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 07-01-2014, 06:35 PM #6
    guitarsweety
    guitarsweety is offline
    Forum Contributor guitarsweety's Avatar
    Join Date
    10-30-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2010
    Posts
    188

    Re: Combobox on Userform not saving selection when form is closed

    Is there anyone out there that can help?
    Reply With QuoteRegister To Reply
  7. 07-01-2014, 06:37 PM #7
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Combobox on Userform not saving selection when form is closed

    Can you upload an example workbook?

    Click on GO ADVANCED and use the paperclip icon to open the upload window.
    Reply With QuoteRegister To Reply
  8. 07-01-2014, 06:43 PM #8
    guitarsweety
    guitarsweety is offline
    Forum Contributor guitarsweety's Avatar
    Join Date
    10-30-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2010
    Posts
    188

    Re: Combobox on Userform not saving selection when form is closed

    Sure, here is the excel file.
    Reply With QuoteRegister To Reply
  9. 07-01-2014, 06:44 PM #9
    guitarsweety
    guitarsweety is offline
    Forum Contributor guitarsweety's Avatar
    Join Date
    10-30-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2010
    Posts
    188

    Re: Combobox on Userform not saving selection when form is closed

    It's the UserFormInput form
    Reply With QuoteRegister To Reply
  10. 07-01-2014, 07:38 PM #10
    guitarsweety
    guitarsweety is offline
    Forum Contributor guitarsweety's Avatar
    Join Date
    10-30-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2010
    Posts
    188

    Re: Combobox on Userform not saving selection when form is closed

    Anyone ......................
    Reply With QuoteRegister To Reply
  11. 07-01-2014, 09:21 PM #11
    guitarsweety
    guitarsweety is offline
    Forum Contributor guitarsweety's Avatar
    Join Date
    10-30-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2010
    Posts
    188

    Re: Combobox on Userform not saving selection when form is closed

    Well I almost have it figured out
    Reply With QuoteRegister To Reply
  12. 07-01-2014, 09:46 PM #12
    guitarsweety
    guitarsweety is offline
    Forum Contributor guitarsweety's Avatar
    Join Date
    10-30-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2010
    Posts
    188

    Thumbs up Finally Figured it Out

    Just figured it out.... Whew
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Userform - Combobox Cell selection Name Range
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-31-2014, 11:29 AM
  2. Userform Combobox to populate based on selection in another combobox
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2014, 03:34 PM
  3. [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
  4. Populating form text box on combobox selection.
    By samtwilliams in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2007, 04:38 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1