Change comboboxes to listboxes

Hi, I have a userform that was created and wish to make some modifications. Firstly, I am trying to the change the dropdown comboxes in the attached form to a listbox. The only reason for the change is to have the user select more than one option. I was hoping a code would exist to make that change instead of reworking the format of the form, but it seems like listboxes is the only way to go.

Secondly, I cant seem to figure out how to make when I hit submit, it opens up microsoft outlook and the subject "A PIR has been submitted to you" automatically enters in the subject line. Is this even possible?

If I cna help some help with the attached document that would be amazing.

thanks you guys.

Hello Jcanguy,

I made some changes to the UserForm. I removed th ComboBoxes and replaced with them ListBoxes. See the screen shot for the changes. Is this what you want or something else?

Muliple ListBox Selection Example

Hello Jcanguy,

The Outlook button isn't a problem. I can easily add that in. But, now that you can select multiple items in the List boxes, will one checked item result in adding a line to the PIR sheet?

Hello Jcanguy,

Can you give me an example of what that would like?

Hello Jcanguy,

Okay, I see now. Each list Box would be on separate line with all the choices listed in the same cell, correct?

Hello Jcanguy,

I made a few changes to your UserForm and tested i. The results look correct to me, but you are the real judge. Test it out and let me know what you find.

Leith,

Thanks for all of your help on this, I just want you to know that you have done a fascinating job helping me. You've expanded the boundaries of impossibilities for me and I really appreciate it. I ran the trial userform, and everything works well (codes etc), however instead of having three rows entered after clicking submit, could it only be one row? Each row is one submittal and only that error type should show in the PIR worksheet and then the different error details would be in the cell next to it, separated by comma.

So if Patient ID is checked under preanalytical, then only preanalytical as an error type and Patient ID as error detail would be transferred to the PIR worksheet (and all the other information of course) in one row.

I hope I'm making sense, again I really appreciate your help with this project.

Hello Jcanguy,

I made the ListBoxes exclusive. When you make a selection in one ListBox the other ListBoxes' selections are cleared. Outlook is brought up after all the information has been transferred to the worksheet with a subject line of "A PIR has been submitted to you". No recipient(s) is/are included since you didn't specify this information. It can be included. I just need to where the recipient is located and what information you want to send. Here is the code for the main form.

Please Login or Register  to view this content.

Hello Jcanguy,

You're correct that there were three separate entries in the workbook. Each from one of the list boxes. With that said, I am confused about what you want.

The list boxes are now exclusive. Only one will have its selections copied to the worksheet each time the submit button is clicked. So, what am I missing about what you want to do?

Hello Jcanguy,

I thought each entry ,as it is submitted, would be saved to the PIR worksheet and only the last entry would be emailed. From your reply, I believe this not what you intended. If you only want one only line filled in, row 2, each time the submit button is clicked then I can do that.