I have three macros in the module and I want each macro to runs when the user changes the values in the cell (Cell F2) to "first", "second", "third". Cell F2 is a data drop down and it contains a 1: a blank, 2: the word "first", 3: the word "second", 4: the word "third". when the Cell is blank nothing happens, but when it is first or second or third it copy and paste into other cells respectively. I can do it for one event only but I want to be able to do it if the values are involved.
Paste the following code in the correct sheet (in Visual Basic):
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("F2")) Is Nothing Then Exit Sub
If Range("F2").Value = "First" Then Call First
If Range("F2").Value = "Second" Then Call Second
If Range("F2").Value = "Third" Then Call Third
I assumed you called your Events First, Second and Third.