+ Reply to Thread
Results 1 to 6 of 6

Populating a Userform from data in a listbox

  1. #1
    Registered User
    Join Date
    05-05-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    3

    Populating a Userform from data in a listbox

    Dear all,
    I am very new to VBA. I have created a Userform that has multiple tabs. One tab is for new registrations (this is for a membership database), and another tab is used to look up members. Looking up and populating the listbox is not a problem. You can look up a member using last name or by badge number. My issue is this, I want to move the data from the listbox to the userform. That way the members information can be updated. Here is the code I have:

    Please Login or Register  to view this content.

    I keep receiving error #91. Any ideas?

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    Re: Populating a Userform from data in a listbox

    Change

    Please Login or Register  to view this content.
    to

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    05-05-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Populating a Userform from data in a listbox

    Bernie,
    Thanks for the response. That doesn't seem to make a difference.

  4. #4
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    Re: Populating a Userform from data in a listbox

    It did for me - controls on pages of a multipage control are not addressed using the "me" object - but that may not be the only issue with your code, and how it interacts with your workbook. Post a copy - shortened, cleaned up, whatever - if you want real help.

  5. #5
    Registered User
    Join Date
    05-05-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Populating a Userform from data in a listbox

    Bernie,
    I made some adjustments after looking at it some more. The main issue I think that was happening is that I had a couple of text boxes locked, then I think the order was not correct (the listbox vs. the txt boxes). You were completely correct that I had more errors. I really appreciate your help. Its what got me to the answer:

    Please Login or Register  to view this content.

  6. #6
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    Re: Populating a Userform from data in a listbox

    Great - I'm glad you figured it out - as long as it works!

+ 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] Populating a UserForm ListBox with all Open workbooks
    By JoshExcel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-09-2014, 09:30 PM
  2. Populating data into listbox based on 3 combo box's using a userform
    By Louis Dean in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2014, 06:39 AM
  3. two listbox populating on userform for chartrange
    By kmsoni in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-28-2011, 11:36 AM
  4. listbox populating on userform
    By kmsoni in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-23-2011, 11:18 AM
  5. Populating a userform listbox from a database
    By James_B in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-12-2010, 02:16 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