TextBox Entry based on Combobox Selection

[tigerdel]

Good morning All

I have a sheet which contains data that I wish to call to a UserForm

Column A - ID
Column B - Full Name
Column C - Title
Column D - First Name
Column E - Surname

ETC ETC

In UserForm1:

TextBox 17 is to contain the ID (Column A) of the selection made from ComboBox3
Combox 3 looks up the values in Column B
TextBox18 is to contain the Title (Column C) of the selection made from ComboBox3
TextBox1 is to contain the First Name (Column D) of the selection made from ComboBox3
TextBox2 is to contain the Surname (Column E) of the selection made from ComboBox3

etc etc to Column S

The Spreadsheet contains headers which need to be ignored and I have expanded the Table Named [FullName B1:B100] which means there are many blanks cells currently.

I have tried various ways of doing this from my web searches and none appear to work but I suspect I have done something horribly wrong

Any help here greatly appreciated as usual

Many thanks

Derek

[mehmetcik]

You are going down a blind alley

It is far better to use columns 1 to 20 say for text boxes and columns 10 to say 30 for Comboboxes.

Then you could do something like the attached userform.

Please Login or Register  to view this content.

You will have noticed that I use a short macro to call a subroutine whenever a text box is changed.

This keeps my coding simple because I do all te complex coding in my Entry, Change, Keydown, Keyup subroutines and have simple calling subs for each textbox


The attached macro will create all the macros for your textboxes.

open the workbook and click on the button.

The macro will create the macros for 100 textboxes, 300 macros in total