Userform with dynamic Combo boxes and text box fill

[Raylou]

Good Day,
I was hoping that somebody can assist me in VBA code for something simple. I am as green as they come with vba code.
I have read many forum examples, but for cannot get the vba code sorted for my problem.
I have attached a basic sample file.
I would like to create a userform with 2 dynamic combo boxes and a text box. (Later in my project I will add more text boxes and perhaps combo boxes).
I want combobox1 to list the items in column A, without duplication of the same name. I want combobox2 to update according what was selected in combobox1. Then I want the correct number associated with the option chosen in combobox2 to display in textbox1. I also want the option on the userform for the textbox, if I change the number in the textbox it should update the table and replace the original. Obviously it would be nice, before it is done a message box should appear asking the user if you are sure you want to replace the info. 
I think the answer or the code is fairly simple. I have tried many different codes, but can get everything to come together.
Any help would be highly appreciated!
Thank you in advance!

[JRidge]

See if this can be of use.

Regards

JRidge

[Raylou]

Morning JRidge,

Thanks a million, this is perfect to compile the combo box and the text box!

I can use this and will definitely learn from it to adapt my current project accordingly.

Do you know how I should add the code for the text box to update the table column if I enter a different number in the text box that originally was displayed?

Thanks!

Kind Regards,

Ray

[JRidge]

Maybe something like:

Regards

JRidge

[Raylou]

Morning JRidge,

Thanks for your reply.

This will help me a lot!

Once again thanks for you response.

Just a last stupid question, how would I adapt the code if I want column B in ComboBox1, and column C in ComboBox2, and the value or text in Column 4 in textBox1?

Thanks!

Kind Regards,
Ray