+ Reply to Thread
Results 1 to 5 of 5

Can i use 2 different "Worksheet_Change(ByVal Target As Range)" on a sheet?

  1. 03-19-2015, 08:48 AM #1
    Viktor86HUN
    Viktor86HUN is offline
    Registered User
    Join Date
    11-11-2013
    Location
    hun
    MS-Off Ver
    Excel 2013
    Posts
    76

    Red face Can i use 2 different "Worksheet_Change(ByVal Target As Range)" on a sheet?

    Hey

    I have a validation list on my sheet, but i would like to add another one.

    The one present and working right now is:

    Please Login or Register  to view this content.
    And the other i would like to merge:

    Please Login or Register  to view this content.

    Is there some way to do this? help me please?
    Reply With QuoteRegister To Reply
  2. 03-19-2015, 09:11 AM #2
    Viktor86HUN
    Viktor86HUN is offline
    Registered User
    Join Date
    11-11-2013
    Location
    hun
    MS-Off Ver
    Excel 2013
    Posts
    76

    Re: Can i use 2 different "Worksheet_Change(ByVal Target As Range)" on a sheet?

    both of them would be very important
    Reply With QuoteRegister To Reply
  3. 03-23-2015, 04:48 AM #3
    Viktor86HUN
    Viktor86HUN is offline
    Registered User
    Join Date
    11-11-2013
    Location
    hun
    MS-Off Ver
    Excel 2013
    Posts
    76

    Re: Can i use 2 different "Worksheet_Change(ByVal Target As Range)" on a sheet?

    still struggling with the issue
    Is there a way to merge these 2 bad boys?
    Reply With QuoteRegister To Reply
  4. 03-23-2015, 05:22 AM #4
    Blokeman
    Blokeman is offline
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    349

    Re: Can i use 2 different "Worksheet_Change(ByVal Target As Range)" on a sheet?

    Cross-post;http://www.mrexcel.com/forum/excel-q...nge-sheet.html
    Please click the * Add Reputation if this helps
    If solved remember to mark Thread as solved

    "I'm glad to help and this is not meant to sound smart, but either you have super-human vision to see all those controls cleared one by one with the code I posted, or your computer is really slow."
    Reply With QuoteRegister To Reply
  5. 03-23-2015, 08:01 AM #5
    Viktor86HUN
    Viktor86HUN is offline
    Registered User
    Join Date
    11-11-2013
    Location
    hun
    MS-Off Ver
    Excel 2013
    Posts
    76

    Re: Can i use 2 different "Worksheet_Change(ByVal Target As Range)" on a sheet?

    Solved at cross post: MrExcel
    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. Worksheet_Change(ByVal Target As Range) not executing Target inc by 1 as spinner button
    By sdl2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-16-2014, 05:47 PM
  2. [SOLVED] Multiple "ByVal Target As Range"
    By batchy in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-08-2013, 02:50 PM
  3. Newbie How to delete macro "Private Sub Worksheet_SelectionChange(ByVal Target As Range)<"
    By semiplenus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2013, 01:38 AM
  4. Need help creating VBA looping code in "Worksheet_Change(ByVal Target As Range)"
    By jimredfield in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2012, 03:09 PM
  5. [SOLVED] Worksheet_Change(ByVal Target As Range) - set to only update when 3 target cells changed?
    By trillium in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2012, 06:40 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