what is the VBA codes for multi-selected field

[vbasia]

Tools concatenated into a single cell
If you click on Create Project, you see that now you can select the tools needed to complete the project. Once you click on request project and send notification, an email pops up with the data that was inputted into the form. Because the tools field is a multi-selection, I need the selections to concatenate into a single cell so it can be visible on the email, and in the assigned projects tab.

Feedback Email
We want to receive feedback from the category and sourcing managers in order to improve the program. Once a project is complete, we want the lead to click the “request feedback” check box in the assigned projects tab, and have that click trigger a macro that sends an email to the requestor with the questions to answer. I’ve found some answers on the internet that leads me to believe this is possible, but I haven’t been successful in getting it to work.

[Keebellah]

You attached file has no macros, but when you add a a ListBox or Combobox you can select the option MultiSelect True or False, the name says it.

[vbasia]

Hi Hans,

Have the done in alphabetic/Categorized window.

[vbasia]

Hi Hans,

I attached the file

[Keebellah]

If the emails are real please remove private information. I suggest you delete the attached file, or ask the moderator to do so and post a file without this data.
I downloaded it and if I reattach it (if I have a solution for you) I will remove them too.

[Keebellah]

I notice you use external ocx controls which are not present on my machine and that I refuse to use due the compatibility issues they cause.
You Userforms (with date controls) won't work so I cannot check and see what your code does and thus helping you will be difficult.
Sorry for that.

[vbasia]

Hi Hans,

The emails are not real, that's not the real list of email for the macro.
Thank you for trying to help.

I hope someone could help to solve the error in this VBA codes.

[Keebellah]

Okay, sorry, my incorrect assumption
What is the error YOU get?
You didn't mention errors in your question, just how to solve something.
I get the errors because of the ocx control so I cannot execute the macros to test what you have.

[vbasia]

Hi Hans,

After I filled up the create project form and click on request project and send notification tab, an email pops up with the data that was inputted into the form. But the problem is the selected value for Tools field didn't appear in the email. Note: Tools field is multi-selected listbox/combo box.

[Keebellah]

That is not an error. That is incorrect coding.
But, like I mentioned I will not be able to help you because the date picker does not work and I get an error when I try to open the form.