+ Reply to Thread
Results 1 to 1 of 1

Move/Delete items between multiple list boxes in a UserForm that correspond to tables

  1. #1
    Registered User
    Join Date
    01-30-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Move/Delete items between multiple list boxes in a UserForm that correspond to tables

    I am creating a individual event scheduling tool (see Main Sheet pic below). I have 4 independent tables (TC, R1/2, RM, and R9) where they will list the names of individuals that fall under that category.

    I've added the "Add an individual" functionality, and need to create a method to move names between the tables. I created a UserForm (see UserForm pic below) of how I thought this could be accomplished, but need help with the implementation. I've read drag and drop is a possibility, but figured command buttons would be easier.

    Here is my thought process:
    -User clicks the "Move/Delete Raven" button which opens the UserForm
    -User selects an individual in a category and can either click move or delete
    -Delete would immediately delete the individual from that category but not update the tables until the user selects "OK"
    -Move would open up another UserForm with a dropbox (or some sort of selection method) to pick which category to move them to, and update the list boxes
    -The user could move or delete as much as they want without the actual tables being modified, it would just reflect the changes in the list boxes
    -If the user clicks "Reset" it would just call the UserForm_Initialize() Sub that would re-initialize the list boxes with the current table configurations
    -If the user clicks "Cancel" it would just Unload Me

    This was the best way I could think of doing this, you all have any suggestions/improvements? I am definitely not a pro at VBA and will need some help with the programming for this to be functional.

    Main Sheet
    UserForm
    Last edited by salvo2002; 01-30-2014 at 10:01 PM. Reason: fixed images

+ 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. Multiple List boxes on UserForm
    By rallysport096 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2013, 12:02 PM
  2. Move data from multiple tables onto a list to archive and analyse
    By sallyfield in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2012, 11:52 PM
  3. Move items between multiple list boxes
    By gsurge in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2011, 05:01 PM
  4. Replies: 3
    Last Post: 08-24-2010, 09:27 AM
  5. Simple Userform to move list items ALMOST works
    By skysurfer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-01-2010, 03:33 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1