Excel cell multi-select from table

I have a macro-enable workbook with one tab containing task data; This tab is named CutoverHxH. Columns I & K contain data validation which pulls from a list on the tab named Arrays. In column I, the user can select a single value (a person's name). Column J is reserved for a function buttton (per line) if needed. Column K uses the same Data Validation lookup, but I would like to be able to select and display multiple values (2 or more names).

I have attached the workbook for reference. Any suggestion on how I might go about this?

Many thanks!
JohnD
TESTv3.xlsm
LVL 1
John DarbyPMAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gowflowCommented:
When you say:


Column K uses the same Data Validation lookup, but I would like to be able to select and display multiple values (2 or more names).

You mean to say you want to be able thru datavalidation in Col K to be able to select more than 1 item ??

If the answer is yes then it is not possible thru data validation it could be possible thru a combobox set to exctended but this would require additional code to align the combobox on each line each time you select it.

gowlfow
John DarbyPMAuthor Commented:
Thanks Gowlfow; attached is something like what I am seeking. I am just unclear how to implement it in my doc
John DarbyPMAuthor Commented:
OWASP Proactive Controls

Learn the most important control and control categories that every architect and developer should include in their projects.

gowflowCommented:
ok working on it to fix it to your requirement. Got the picture and inline with what I pointed out earlier but here your using a listbox but should be done with a combo. Give me sometime as caught in an other urgent matter and will revert.

That is if no one else beat me on it !! :)
gowlfow
John DarbyPMAuthor Commented:
Appreciate it Gowlfow! Each time I get help here, I have a splendid opportunity to learn how to do this mysefl. :)

Thank you,
JohnD
gowflowCommented:
Yes this is why this site is one of the best if not the best !!!
will revert
gowflow
gowflowCommented:
Check out this is this what you want ? I removed the rectangle you had created and replaced it by an OK button. Any click in Col C will display the listbox with all the items in Col A.

check several items then press OK and see the results in Col E.
go up and down in col C with the arrows and do the same and see.

if all ok then we can implement in your file.
gowflow
Multi-Select-ListBoxSetup.xlsm
John DarbyPMAuthor Commented:
Thanks Gowflow, I will check it out  tomorrow. ..thank you!
gowflowCommented:
ok fine I adapted it to your workbook. click on any cell in Col K then choose from the list and press OK and see results. Go away form Col K and see it should disappear. hovering again on the units will not delete what was there.

Let me know.
gowlfow
TESTv3-V02.xlsm

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
John DarbyPMAuthor Commented:
Amazing job! I like how you implemented where you can edit within the context of the target celles, themselves! Thank you!
gowflowCommented:
Your welcome and glad I could help.

BTW don't know if you noticed but LisFillRange is Dynamic and not fix so that if it grows it will always pickup all items.
gowflow
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.