Specifying List Object for ListObject_Change() Event

[holyasian]

Hey all,

I've been programming in visual basic for almost 3 years, but I've just started exploring Change() events.

I have a worksheet with 3 data tables. One of them (titled "SKUnames"), I want to move to a separate worksheet whenever it is changed or something is added to it. After Googling this issue, I found a nifty event called ListObject_Change(), which would fire whenever a list object is changed on my worksheet.

However, I'm not sure how to specify the specific list object on my worksheet to change. Is this possible? Attached is my petty attempt at figuring out a solution.

Any help is much appreciated. Thanks in advance!

Best,
Wes

Code:

Please Login or Register  to view this content.

[nilem]

Hi holyasian,
maybe so

Please Login or Register  to view this content.

[holyasian]

nilem,

That worked like a charm. Thanks for the quick and efficient reply!

-Wes