+ Reply to Thread
Results 1 to 3 of 3

Run macro when data validation drop down box is changed code bug help

  1. 08-12-2016, 07:16 AM #1
    Gti182
    Gti182 is offline
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    457

    Run macro when data validation drop down box is changed code bug help

    Hi All,

    Having trouble with below code which activates when Cell D6 in a drop down box is selected to "Yes".

    Code executes as i would like but it crashed my excel pretty much instantly once executed. Is this due to the code continuously running because D6 is "Yes"?


    Please Login or Register  to view this content.
    Last edited by Gti182; 08-12-2016 at 08:21 AM.
    Reply With QuoteRegister To Reply
  2. 08-12-2016, 07:23 AM #2
    LeoTaxi
    LeoTaxi is offline
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Run macro when data validation drop down box is changed code bug help

    Try like this

    HTML Code: 
    Kind regards
    Leo
    Reply With QuoteRegister To Reply
  3. 08-12-2016, 08:21 AM #3
    Gti182
    Gti182 is offline
    Forum Contributor
    Join Date
    10-04-2010
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    457

    Re: Run macro when data validation drop down box is changed code bug help

    worked perfectly thanks LeoTaxi!

    was doing my head in!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. MACRO REQUIRED - Paste results from Data Validation drop down into separate tabs
    By FULTANIO in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2015, 06:38 AM
  2. [SOLVED] VBA Code to copy cell value on another sheet on drop down list changed
    By aftermath09 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-16-2015, 12:27 AM
  3. Hello i need macro which will choose next and previous in data validation drop down list
    By k_2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2014, 04:59 AM
  4. [SOLVED] Broken drop-down list due to its contents being changed with a macro
    By mdovey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-13-2014, 01:10 PM
  5. Macro runs from Data Validation Drop Down List Selection
    By flindy87 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-28-2013, 11:45 AM
  6. VBA code silently crashing. Problem with Data Validation drop down lists.
    By Don Wiss in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-28-2012, 10:01 PM
  7. [SOLVED] How can the font in the Data Validation list be changed?
    By Pat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2006, 11:00 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1