Dependent ComboBoxes in Userform, then Submit Button

Hi Experts,

May I request for your assistance with what I am doing now. I have a file with a userform where this is what I want to happen:

ComboBox1 will have a dropdown with name selection (Example. Helper1, Helper2, Helper3)
TextBox1 will be entered with EID (found in Masterfile Tab/Sheet)
ComboBox2 will display list of Call Types (Found in List Tab/Sheet)
ComboBox3 will display list of Assistance Types (Found in List Tab/Sheet)
ComboBox4 will display list of Sub Category (Found in List Tab/Sheet and dependent with Assistance Type)
ComboBox5 will display list, either "Yes" or "No".

CommandButton1 will transfer information in "Tracker" Tab/Sheet based on column value.
I'm also looking to see for posibilities of having a timestamp whenever I click submit button (Date and time on Column A and B.

Thank you!

This should get you started....

Please Login or Register  to view this content.

I wasn't sure where the name was supposed to go since there is 2 places it could go. Also, sub category list didn't have anything in it.

I'm a little confused.
1)You want the name, or EID# in column D?
2)The Call type list on the userform shows assistance type (explanation, Task_Walk_Through, etc.). Should it be APC, ASG and Other?

You've marked this as Solved...did you get it figured out?

Your welcome, glad I could help.