+ Reply to Thread
Results 1 to 4 of 4

multiple instances of worksheet_Change help

  1. #1
    Forum Contributor
    Join Date
    03-30-2015
    Location
    Northampton
    MS-Off Ver
    2010
    Posts
    275

    multiple instances of worksheet_Change help

    hi all, i have the following code which i use in worksheet_change, i have all my databases on one worksheet and want to keep it that way. the code that i use adds a date and time of an entry and also a date and time of when entry was amended. the first code works as it should, however i would like to do the same in different areas of my work sheet hence the second code.

    Please Login or Register  to view this content.
    and this is the second code id like to add

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    08-03-2012
    Location
    Newcastle
    MS-Off Ver
    Excel 2007, 2010, 2013, 2016, Office 365
    Posts
    467

    Re: multiple instances of worksheet_Change help

    Hi

    Try this (not tested)..
    Please Login or Register  to view this content.
    zeddy

  3. #3
    Forum Contributor
    Join Date
    03-30-2015
    Location
    Northampton
    MS-Off Ver
    2010
    Posts
    275

    Re: multiple instances of worksheet_Change help

    hi i got the following error

    Attachment 679047

  4. #4
    Forum Contributor
    Join Date
    03-30-2015
    Location
    Northampton
    MS-Off Ver
    2010
    Posts
    275

    Re: multiple instances of worksheet_Change help

    Just and update, i managed to get the code working the way i need it to as follows, all databases are on one sheet.
    Please Login or Register  to view this content.

+ 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. Multiple Worksheet_Change macros - How to edit exisiting code to allow for multiple
    By David.Jerzy.H in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2019, 03:59 PM
  2. Replies: 8
    Last Post: 09-14-2013, 12:53 PM
  3. [SOLVED] Complex VLOOKUP, multiple instances vertical, return subsequent instances horizontally
    By Miles_2804 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-12-2013, 11:54 AM
  4. [SOLVED] How to Combine 3 instances of Worksheet_Change(ByVal Target As Range)
    By Grumpygrandad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2013, 11:12 PM
  5. Inputting data from multiple instances from multiple users into a main Excel Workbook
    By smooth_beaker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2013, 12:18 AM
  6. Count instances of a string across multiple columns with multiple criteria
    By rpthoth in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-01-2012, 09:23 AM
  7. macro for saving multiple instances of an xls in multiple formats.
    By tomotron in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-29-2008, 12:01 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