Results 1 to 10 of 10

Multiple event macros in a sheet!

Threaded View

  1. #1
    Registered User
    Join Date
    06-02-2020
    Location
    Thailand
    MS-Off Ver
    2013
    Posts
    8

    Multiple event macros in a sheet!

    Hi all,

    I want to run multiple event macros in the same sheet but being a newbie, I can't figure out how to do it. Below are my two events.

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
        Range("A1").Value = ActiveCell.Address
    End Sub
    Private Sub Worksheet_Change(ByVal Target As Range)
    
    If Target.Row = 3 And Target.Column = 6 Then
    
    Application.EnableEvents = False
    
    Sheets("List").Range("F4").Value = [=IFERROR(VLOOKUP($F$3,Data!$A$1:$C$7,2,0),"")]
    
    Sheets("List").Range("F5").Value = [=IFERROR(VLOOKUP($F$3,Data!$A$1:$C$7,3,0),"")]
    
    
    End If
    
    Application.EnableEvents = True
    
    
    End Sub
    Thank you for your time and help.
    Last edited by itskenn1; 08-01-2021 at 02:55 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Multiple Macros on Single Sheet
    By eeacolyte in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 01-05-2022, 04:43 PM
  2. Multiple macros for one work sheet
    By heggej in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2019, 11:04 AM
  3. [SOLVED] VBA Macros single event (Enter & Exit) for multiple userform textboxes
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-09-2019, 12:54 PM
  4. Multiple Macros on this spread sheet ... NEED HELP!
    By potthoffw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2016, 11:19 AM
  5. Same VBA event multiple times in one work sheet
    By glenn0004 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-28-2015, 11:37 AM
  6. [SOLVED] Simple error: List multiple sheet names in Workbook_SheetActivate event
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-01-2015, 05:44 AM
  7. [SOLVED] Multiple Macros From Multiple Dropdown Lists on one sheet.
    By MagyarLou in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-29-2013, 04:33 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