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
I have attached the workbook for reference. Any suggestion on how I might go about this?
Many thanks!
JohnD
TESTv3.xlsm
ASKER
Thanks Gowlfow; attached is something like what I am seeking. I am just unclear how to implement it in my doc
ASKER
Attaching now...
Multi-Select-ListBoxSetup.xlsm
Multi-Select-ListBoxSetup.xlsm
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
That is if no one else beat me on it !! :)
gowlfow
ASKER
Appreciate it Gowlfow! Each time I get help here, I have a splendid opportunity to learn how to do this mysefl. :)
Thank you,
JohnD
Thank you,
JohnD
Yes this is why this site is one of the best if not the best !!!
will revert
gowflow
will revert
gowflow
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
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
ASKER
Thanks Gowflow, I will check it out tomorrow. ..thank you!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Amazing job! I like how you implemented where you can edit within the context of the target celles, themselves! Thank you!
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
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
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