+ Reply to Thread
Results 1 to 5 of 5

UserForm Initialization does not load items in ComboBox, Option values won't transfer etc.

  1. #1
    Registered User
    Join Date
    05-16-2011
    Location
    Virginia Beach, Virginia
    MS-Off Ver
    Excel 2007
    Posts
    22

    UserForm Initialization does not load items in ComboBox, Option values won't transfer etc.

    I'm building a Lessons Learned Database that employs several different dropdown lists, most work, but the .additem method does not. Additionally the Category and SubCategory values will not transfer correctly to the spreadsheet - totally perplexed why. The UserForm1_Initialize function does not work and I can't figure that out either. The navigation is controlled primarily through the scrollbar value. I've attached the spreadsheet and commented within the code where issues are. Any help is deeply appreciated.
    Attached Files Attached Files

  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 Initialization does not load items in ComboBox, Option values won't transfer

    It's Private Sub UserForm_Initialize() not Private Sub UserForm1_Initialize().
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    05-16-2011
    Location
    Virginia Beach, Virginia
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: UserForm Initialization does not load items in ComboBox, Option values won't transfer

    That was a huge help - I couldn't see the forest for the trees! Thanks. Now that allowed me to further test the form and the Option Box values are correctly being placed however the "Next", "New" buttons are not working as planned. The records are not incrementing - I'm using the scrollbar value to increment them and it appears from my point that they should. Help?

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

    Re: UserForm Initialization does not load items in ComboBox, Option values won't transfer

    Might be something for a new thread.

  5. #5
    Registered User
    Join Date
    05-16-2011
    Location
    Virginia Beach, Virginia
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: UserForm Initialization does not load items in ComboBox, Option values won't transfer

    Roger that - Thanks again.

+ 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. 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
  2. Combobox (picture load to userform)
    By naseerrurahaman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-01-2013, 09:55 AM
  3. Load Userform ComboBox with filtered data
    By anandvh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2012, 05:34 PM
  4. load userform from a combobox in another userform
    By ncaravela in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2010, 04:57 AM
  5. Load items in combobox
    By minn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-13-2008, 12:53 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