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!
Bookmarks