+ Reply to Thread
Results 1 to 4 of 4

Two Seperate 'worksheetchange' in one Workbook

  1. #1
    Registered User
    Join Date
    11-18-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    2

    Post Two Seperate 'worksheetchange' in one Workbook

    I am aware that it is impossible to have two VBA Worksheet Changes in one workbook. However, I have 2 macros that I require to operate for my model to work properly. These are as follows:

    1, Data Validation Code that allows users to add new entries to Drop Downs (and update the respective table)
    Please Login or Register  to view this content.
    2, VBA that allows multiple selections in drop down menus, then displays them one after another in the cell.
    Please Login or Register  to view this content.
    Is it possible to combine these two pieces of code? I am on a tight deadline with this so any help would be greatly recieved.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646

    Re: Two Seperate 'worksheetchange' in one Workbook

    The short answer is yes.

    You might need to adjust things a bit to accomodate both sets of code.

    For example get rid of the Exit Sub in the first code to allow code execution to move onto the second code.
    Last edited by Norie; 11-19-2013 at 07:10 AM.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    11-18-2013
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Two Seperate 'worksheetchange' in one Workbook

    Thanks Norie. Could you point me in the right direction with the rest of the code as my VBA knowledge is quite l

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646

    Re: Two Seperate 'worksheetchange' in one Workbook

    Don't really have time right now to look at the code closely - think a look at the workbook might be needed.

    You could try just kind of sticking the second code after the first and getting rid of the Exit Sub.

    Like this:
    Please Login or Register  to view this content.
    That code compiles but I can't guarantee it'll work properly.

+ 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] Master workbook to pull data from second workbook into seperate sheet
    By djm601 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-16-2013, 09:24 AM
  2. Filter data on seperate workbook and paste on current workbook
    By ZeDoctor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2012, 08:08 AM
  3. WorksheetChange function to run only on changed cells
    By LouiseH24 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-15-2011, 11:12 AM
  4. Updating 4 cells (2 of them Merged) with WorksheetChange Event
    By ron2k_1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2011, 12:24 AM
  5. Named cells in a worksheetchange macro instead of hard cell refere
    By Neil Goldwasser in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2005, 10:05 AM

Tags for this Thread

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