Worksheet Change Sub seems to create issues with Application

[sorensjp]

Hello all,

Firstly, I hope your all SAFE.

I am having problems with loading "Products" from the Products_DB (Sheet 3) onto Products_Control (Sheet 12) when I use the this:

Sheet 12 Code-

Please Login or Register  to view this content.

When I enable the Sheet 12 Worksheet_Change Code the Application seem to run into a snags. For instance, when I click into a cell with the Table "tblProduct_DB" doe not show in the Table Name block in the Design Tab. It does show up when I use the dropdown in the Named Ranges area in the Formula Bar.

When I run the code the code below on it's own it seem to run fine without the Sheet 12 Worksheet_Change. I'm attempting to incorporate the use of Tables and Structured References in my named ranges.

Sheet 3 Code

Please Login or Register  to view this content.

Thank you in advance for your assistance.

V/r,
Jim

[Keebellah]

I have not yet looked at you excel file but you should include application.enablevents check to avoid it to run into a loop.
So when the enent is triggered you set this to false until it's completed and not forget to set it back to true, this is the only thing that I can come up with having looked at your file.

[PCI]

As Keebellah explained try next code

Please Login or Register  to view this content.

[sorensjp]

Keebellah,

Thank you. Your advice works like a charm.

I hope you have good health and continue to be safe.

V/r,
Jim

[Keebellah]

Great, to read.

[sorensjp]

PCI,

Thank you for the Code. I was not sure as to where to place the Application.EnabelEvents line w/in my code.

I have adjusted where I place them and it seems to work the same as where I placed them. I just don't understand how it actually works.

Be Safe. Thank you for your time.

V/r,
Jim

[PCI]

Glad to help and thank you for the Rep.