Where should my ListBox code go?

[j_Southern]

I Have 2 ListBoxes on a UserForm
I want the RowSource of one ListBox to be chosen by the Value of the first ListBox .
The following code is meant to achieve this.

Please Login or Register  to view this content.

This sub is not activated probably because it is in the wrong place in the code of the UserForm.
I have tried other places but none get the sub to be run. Where should it go?
John

[Fluff13]

Is LBName a single or multiple select listbox?

[romperstomper]

Put it into/call it from the LBMc change event, and remove the period in front of "Me".

[j_Southern]

I am now calling from LBMc change event and the procedure is now being activated. After you found the faulty point I changed the code to this

Please Login or Register  to view this content.

which seems to be correct. However on line 10 I am getting a type mismatch error. The named ranges are in position so I am at a loss as to how to progress. Can you help a bit more?
John

[Fluff13]

Using RowSource you need to supply an address

Please Login or Register  to view this content.

[romperstomper]

Or just use the name directly:

Please Login or Register  to view this content.