+ Reply to Thread
Results 1 to 2 of 2

Listbox on userform population and modification

  1. #1
    Forum Contributor
    Join Date
    10-13-2015
    Location
    California
    MS-Off Ver
    Office 2013
    Posts
    138

    Question Listbox on userform population and modification

    I have attached a workbook with a userform and another workbook that acts as a table.

    What I would like is some help with the listbox portion of the userform or if anyone can think of a better way to do what I want done than please suggest it.

    okay so to the chase. A user will use the userform to fill in vehicle information submit the information which I have writing to a table file in another location. if you look at the code I removed the location from the file so if you do testing you will have to relink the table file. This portion works the way I intended. What I would now like to do is to populate the listbox with the data from any rows on the table that do not have a date in the returned date field of the table file only displaying columns B:G. With that selection I would like to be able to click the returned button on the userform to enter todays date in the date returned field for that specific line thus removing it from the "Pending" listbox.

    If anyone can help that would be great, I have limited experience in VBA and just recently started exploring with userforms.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Listbox on userform population and modification

    Hi,
    I use something similar, so try this piece of code for the first part of yr request, hope it helps you!
    Please Login or Register  to view this content.
    Last edited by john55; 01-08-2017 at 06:58 AM.
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

+ 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. Listbox and textbox population
    By molesy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2014, 06:40 AM
  2. Listbox to Listbox, no duplicates & submitting same UserForm data for each Listbox entry.
    By jamieswift1977 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2012, 12:18 PM
  3. Complex ListBox Population
    By abhishekchak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-01-2012, 06:28 AM
  4. Userform with Data Entry and Listbox Population
    By BigSi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-01-2011, 09:40 AM
  5. ListBox Population issue
    By efernandes67 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2009, 06:19 PM
  6. Modification of listbox to listbox code
    By Sam S via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-28-2005, 07:05 AM
  7. [SOLVED] Multiple Listbox? Population
    By Pete in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2005, 11:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1