+ Reply to Thread
Results 1 to 3 of 3

Monitor multiple changes in a range. Help PLzz

  1. #1
    Registered User
    Join Date
    12-16-2016
    Location
    morocco
    MS-Off Ver
    2016
    Posts
    10

    Question Monitor multiple changes in a range. Help PLzz

    Hello!
    I' am using the following code to monitor changes in specific ranges and it works just fine.

    Set HEK = Range("D2:D25,K2:K25,R2:R25,Y2:Y25,AF2:AF25,AM2:AM25,AT2:AT25,BA2:BA25,BH2:BH25")
    If Not Application.Intersect(HEK, Range(Target.Address)) _
    MsgBox Target.Value
    Endif

    The issue i am having is that when i make change to several cells at once it come with the following error : Run-time error '3': Type mismatch.
    is there a possible way to make the "msgbox" pop up separately for each change one following an other ??

    thanks in advance

  2. #2
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    Earth
    MS-Off Ver
    2016
    Posts
    692

    Re: Monitor multiple changes in a range. Help PLzz

    Application.Intersect returns a range object; Excel assumes you mean Range.Value when you write it to the message box which is fine when the range is one cell, but the range of multiple cells has no value property. Try this:
    Please Login or Register  to view this content.
    MatrixMan.
    --------------------------------------
    If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
    If your issue is now resolved, remember to mark as solved - click Thread Tools at top left of thread.

  3. #3
    Registered User
    Join Date
    12-16-2016
    Location
    morocco
    MS-Off Ver
    2016
    Posts
    10

    Re: Monitor multiple changes in a range. Help PLzz

    That's exactly what I need, thank you matrix

+ 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] Cell Function to Monitor a Specific Range
    By T86157 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-28-2015, 11:12 AM
  2. [SOLVED] Monitor multiple cells for an input event
    By iwannabakat in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-08-2014, 02:53 AM
  3. [SOLVED] Monitor date and time range
    By smcelv1 in forum Excel General
    Replies: 5
    Last Post: 06-13-2012, 09:15 AM
  4. plzz i need help
    By hatemhatem in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2010, 03:36 PM
  5. [SOLVED] Enlarge picture in a cell comment, PLZZ some advise
    By KostasH in forum Excel General
    Replies: 1
    Last Post: 04-07-2006, 09:55 AM
  6. How to display multiple pages on one large monitor
    By mrkrug3 in forum Excel General
    Replies: 1
    Last Post: 06-23-2005, 09:05 PM

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