would like to create a UserForm for my database. I know how to create a basic one but what I would like to do it’s a little bit advance, that’s why I am asking some help.
Basically, I would like a ComboBox defined by the column “name”, so the code has to look in which column is the header “name” is, and then list all the name in the combo box.
Name Surname Tel Country City Order
John Zachary 089902 USA Boston 909920
Mike Conway 919888 USA Raleigh 928292
... .... .... ... .... .....
Depending on the selection of the name (inside the ComboBox) all data related, which is in the same row, has to appear in the user form in different Textbox.
In the UserForm I would like to have all headers as label and the data next to it in a textbox. And if a header is added the user form should create by itself the label (name of the new header) and the textbox with the data.
On top of that I would like to be able to modify information via the userform in the textbox and update the excel sheet.
I am really grateful for your help.
Thank you in advance.