+ Reply to Thread
Results 1 to 5 of 5

VBA code works in excel 2003 but not 2007?

  1. #1
    Registered User
    Join Date
    11-05-2015
    Location
    South Florida
    MS-Off Ver
    2003
    Posts
    5

    Question VBA code works in excel 2003 but not 2007?

    I have VBA code to force the user to select values from drop down lists when a value is selected from another drop down list. When "NONE" is selected from the first list the other lists are greyed out and set to N/A. When "USE BY DATE" is selected from the first list, the user is forced to select values from the other three lists. The code works in excel 2003 but when I run it on 2007 (at work), I get all kinds of debug errors and crashes. I am not very proficient with excel programming so I am hoping you guys can tell me why this is happening or clean up the code for me. Thanks in advance for your time and knowledge.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: VBA code works in excel 2003 but not 2007?

    Maybe:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    19,936

    Re: VBA code works in excel 2003 but not 2007?

    Was it really working?
    You need to set the EnableEvents property to False and back to True when you change the cell value, otherwise it will loop endlessly.

    i.e
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    11-05-2015
    Location
    South Florida
    MS-Off Ver
    2003
    Posts
    5

    Re: VBA code works in excel 2003 but not 2007?

    Thank you guys! I made the changes and it works perfectly.

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: VBA code works in excel 2003 but not 2007?

    Hi Gasp,

    Thanks 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] Macro works in Excel 2007 but not compatible with 2003
    By lewap90 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-18-2015, 06:02 PM
  2. Function works on Excel 2003, but not on 2007
    By tonnerre2000 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-31-2014, 04:33 PM
  3. Formula works in Excel 2007 but not in 2003
    By mort.marshall.20 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-19-2013, 12:06 AM
  4. Migration from Excel 2003 to Excel 2007 and chart naming code no longer works...
    By SteHawk85 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-05-2012, 10:14 AM
  5. Code works fine in 2003 excel but fails in 2007
    By tanimytani in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-10-2012, 11:40 AM
  6. ODBC works in excel 2003 but fails in 2007
    By Harle000 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-2011, 10:58 AM
  7. Macro works fine in Excel 2003 but not in 2007
    By jackdebnam in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2011, 12: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1