Results 1 to 4 of 4

error in worksheet_change event

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-10-2019
    Location
    england
    MS-Off Ver
    2013
    Posts
    486

    error in worksheet_change event

    Hi,
    I have a sample file, where i have macro to get a vlookup as dropdown using custom function exist..
    i want the trigger event to fire, when the user manually chooses from the dropdown and not when macro runs..
    But this event interfere with macro and it hampers its functioning..
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do I use the worksheet_change event?
    By JohnJK04 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2015, 07:51 PM
  2. [SOLVED] Worksheet_Change Event - Target.Name.Name error in certain situations
    By GazP in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-18-2013, 04:14 AM
  3. Run time error 13 when deleting more than one cell with Worksheet_Change event macro
    By som3on3_10 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-22-2010, 12:19 PM
  4. Worksheet_Change Event won't run more than once
    By David McMillon in forum Excel General
    Replies: 2
    Last Post: 07-08-2010, 04:02 PM
  5. Using Worksheet_Change Event
    By John99 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2009, 08:26 AM
  6. Worksheet_Change Event
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-24-2009, 04:45 AM

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