Hi,

I am new to VBA and I am trying to manipulate a form that someone else created within Excel. The form has 3 ActiveX ComboBoxes (UnitComboBox1, TypeComboBox1, TaskComboBox1) among other things (checking rows for data, submitting form to email list, approve, disapprove buttons that goto different email lists).

There are a few things that I would like to do with my ActiveX comboboxes
1.) First when a user selects from the UnitComboBox1, based on the Unit they select, it populates the TypeComboBox1, and then again when a user selects the TypeComboBox1, based on the Type they select, it populates the TaskComboBox1.
2.) Depending on the combinations that the user selects of the 3 combo boxes, it needs to send the form via email to a select group of people (for which I have created an array).

I know this is possible, but have not been able to find an example of how to do 3 combo boxes, using SelectCase and being that I am new to all of this, I don't even know where to begin to VBA code this using Active X.

There are also different email lists (depending on the selections in the comboboxes) that this form will get sent to.

Hope I am making sense....ANY help/guidance would be GREATLY appreciated.

I have included the Excel sheet VB below. Thank you!

VB@N3wb|3

Please Login or Register  to view this content.