Re: Make a macro run when data entered in a cell -multiple eventSolved/Closed

Question

Hello, 
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. 
pls, help
thank you

TrowaD · Answer

Hi Tosinsog,

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
End Sub

I assumed you called your Events First, Second and Third.

Best regards,
Trowa

Re: Make a macro run when data entered in a cell -multiple event

1 reply

Similar discussions

Subscribe To Our Newsletter!