I'm stumped on this one. I've tried every method of keyword search I can on Google and all of the Excel boards I know and I'm sure this must have been asked before but I can't figure out the right combo of search terms to find it!
I have a User Form with a multi-select ListBox populated by a named range that works just fine for users to make selections then write the selections to a row in a sheet. Now I want the users to be able to open a User Form (or the same User Form, if that's better) to EDIT the item's they've selected. I can't figure out how to get the Listbox to show which items have already been selected!
Here's how the spreadsheet works now:The main data is in a spreadsheet/table called Project Tracker. The users enter a main team owner (e.g. "Development Owner") then choose "yes" in the next column to indicate whether or not there are sub-team members. If they choose "yes", it opens a User Form for the Development team with a list of team members that can be added. The User Form shows the project ID, project name, and development owner for the row that launched the User Form. Once the user makes their name selections, the form writes to a DIFFERENT spreadsheet ("Sub Team Members"), uniquely identifying each row by project ID and team (so there should only ever be 3 possible entries for each project ID - one each for Design, Development, and Delivery). I then concatenate the entire list of names and display it (using Index/Match) in the main spreadsheet for reference.
I want to allow the user to click on the concatenated reference list of names in the main spreadsheet to open the new/existing User Form (whichever is better) and see the existing selections to change them or add to them.
I'm not sure which elements of my code to post for fear of putting extraneous info here that isn't relevant but I've attached a stripped down version to show what I'm doing.
Project Calendar for Review.xlsm
I hope I was clear enough this time to grab someone's attention. I try to post as infrequently as possible and figure things out myself, but no amount of searching or trial-and-error seems to be working this time!
Thanks all!
Lori
Bookmarks