comboboxes in userform, submit buttons opens outlook.

[Jcanguy]

Hi, I created this userform and looking to make a few changes to it. The checkboxes you will notice in the attached file I want to replace with comboboxes with the same labels. I tried several different options but it didn't work.

Also, is there way so when the submit buttom is clicked, it opens microsoft outlook and the information submitted would be transferred in an email? Any help, suggestions would be highly appreciated.

[Leith Ross]

Hello Jcanguy,

I removed the check boxes and added three combo boxes: PreAnalytical, Analytical, and PostAnalytical. These controls have their RowSource properties set to named ranges on the "Types of errors" worksheet. The ranges are dynamic. That is the range address will automatically adjust when data is added or removed.

I assumed there would be one type of error and error description entered on the worksheet. When a choice is made in a combo box, the others are cleared. The error type and description are saved in the variables ErrorType and ErrorDesc.

No code has been added to launch Outlook. You didn't say what data you want sent in the email, nor who the recipient will be, or how the body of the email be formatted. Once that is known, the code can added. Have a look at the attached workbook and let me know if this close to what you want.

[davesexcel]

Check out excels help file on ComboBoxes as well

A code is supplied there to populate a ComboBox,

Please Login or Register  to view this content.

[Jcanguy]

Leith,

Here are the changes I made. In regards to the email, I'm hoping there is a code that would automatically open Outlook on the machine been used, so that the user can enter the "To" email address. The subject line, should always be "A PIR has been submitted to you". This sounds so ideal, I'm not even sure its possible.

[Leith Ross]

Hello Jcanguy,

You made some changes to the user form and two of the Combo Boxes names changed. I made the corrections. It should work correctly now. See the attached workbook.

[Jcanguy]

Leith,
Thanks very much for your help. It appears there are still some errors when I hit the submit button. The error seems to be pointing to the submit and outcome textline, even though those are corrected. Were you able to submit the information without any problems?

Thanks again,
jcanguy

[Leith Ross]

Hello Jcanguy,

The error occurs when writing to column "H". This text box txtOutcome is not on the user form. I don't see anything else on the form that might relate to this. What do you want to do with this missing text?

[Leith Ross]

Hello Jcanguy,

This version simply ignores the errors created by text boxes that do not exist. The information transfers from the user form to the worksheet now. Please check it for accuracy.

[Jcanguy]

<Solved>Thanks! it works amazing!