How to create database dynamic userform VBA?

August 22, 2015 at 23:36:51
Specs: mac
Hello everyone,

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.

See More: How to create database dynamic userform VBA?

Report •

September 16, 2015 at 03:22:58
You mention Database then you mention Excel, can you clarify what application you are using?

Report •
Related Solutions

Ask Question