Re: Make a macro run when data entered in a cell -multiple event
Solved/Closed
tosinsog
Posts
1
Registration date
Thursday May 23, 2013
Status
Member
Last seen
May 23, 2013
-
May 23, 2013 at 06:23 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - May 27, 2013 at 10:57 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - May 27, 2013 at 10:57 AM
Related:
- Re: Make a macro run when data entered in a cell -multiple event
- Run macro when cell value changes - Guide
- Which key is used to make multiple line in a single cell - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Allow multiple downloads chrome - Guide
- Automatically run a macro when opening a worksheet - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
547
May 27, 2013 at 10:57 AM
May 27, 2013 at 10:57 AM
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
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