+ Reply to Thread
Results 1 to 7 of 7

Worksheet Change Sub seems to create issues with Application

  1. #1
    Forum Contributor sorensjp's Avatar
    Join Date
    12-23-2015
    Location
    Yokosuka, JP
    MS-Off Ver
    2007 and 2016
    Posts
    190

    Worksheet Change Sub seems to create issues with Application

    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

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    7,221

    Re: Worksheet Change Sub seems to create issues with Application

    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.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,661

    Re: Worksheet Change Sub seems to create issues with Application

    As Keebellah explained try next code


    Please Login or Register  to view this content.
    - Battle without fear gives no glory - Just try

  4. #4
    Forum Contributor sorensjp's Avatar
    Join Date
    12-23-2015
    Location
    Yokosuka, JP
    MS-Off Ver
    2007 and 2016
    Posts
    190

    Re: Worksheet Change Sub seems to create issues with Application

    Keebellah,

    Thank you. Your advice works like a charm.

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

    V/r,
    Jim

  5. #5
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    7,221

    Re: Worksheet Change Sub seems to create issues with Application

    Great, to read.

  6. #6
    Forum Contributor sorensjp's Avatar
    Join Date
    12-23-2015
    Location
    Yokosuka, JP
    MS-Off Ver
    2007 and 2016
    Posts
    190

    Re: Worksheet Change Sub seems to create issues with Application

    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

  7. #7
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,661

    Re: Worksheet Change Sub seems to create issues with Application

    Glad to help and thank you for the Rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Issues w/t Application Match
    By brentjohn in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 01-11-2020, 11:41 AM
  2. Application.Calculation issues
    By c.davidson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-14-2018, 06:52 AM
  3. Userform worksheet change performance issues
    By Sazza in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 11-14-2016, 07:16 AM
  4. Application.GetSaveAsFilename Issues on MAC
    By jblack6572 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-24-2015, 12:57 PM
  5. Application.Onkey issues
    By skb_yfc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-09-2015, 09:56 PM
  6. [SOLVED] VBA code to change the application.username and application.userinitials
    By jwlamb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2014, 11:25 PM
  7. Issues with Application.DisplayAlert = False
    By euro_andres in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-25-2012, 05:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1