extend a named range with VBA

[MoritzCH]

Hi,

I have to "develop" a new time management excel solution for our departement and facing some problems (VBA - beginner). I am using a userform as interface and would like to add new items based on a textbox value and command button click to a named range.
Let's say I have a sheet called "Konfiguration" and in column "C" is a header (KE Mitarbeiter") and below are 2 existing employees. How can I add a new employee so the dynamic range (name is "KEM") will be extended and sort alphabetically?

This list is going to be a rowsource for several comboboxes.

Thank you in advance
Moritz

[Olly]

Create a dynamic named range (I named this one KEM), something like:

Please Login or Register  to view this content.

Now in the worksheet module, enter:

Please Login or Register  to view this content.

[MoritzCH]

Think you got me wrong. I would like to use a userform with a textbox and a command button. You can enter a new employee into the TextBox and when you click the command button the named should be added to the list. The userform is created with VBA. (ALT + F11)

I attached a simplified sheet for better understanding


---> demo.xlsm

[Olly]

Always easier with a workbook.

It's a table, not a named range. So try:

Please Login or Register  to view this content.

Does THAT do what you want?

[MoritzCH]

GREAT!

Thank you very much