create a dynamic dependent list in excel vba

Hi again dear forum :-)
As you may remember, I´m using internet and youtube to learn VBA.
I learned how to create dependent comboboxes

Please Login or Register  to view this content.

But it´s static, and now I´m trying to create a dynamic. I coudn´t found any info about that, so I came up vith this

Please Login or Register  to view this content.

which unfortunatrly not working
Pease help me solve this

Your halp will *** always be appreciated
Regards
Peter

Hi Peter,

Try changing your Named Ranges to dynamic.

For example: change your named range for "yrke" to

Please Login or Register  to view this content.

The OFFSET and COUNTA functions will cause the Named Range to grow with your list.

Hope this is helpful.

Cheers

thanks southward for your suggestion, but I solved it eventually with the following code

Please Login or Register  to view this content.

You are welcome.