Run a Macro when value is... Closed

Question

Hello! I have been trying to run a Macro within a worksheet. Running the macro depends on the value of a cell, it can be 6 or 4 (Changes depending on a calculation).  If its 4, I need to run MacroA, and if its 6, I need to Run MacroB.

I know that I need to go to the Visual Basic but can't figure out the lines! Can someone help me please!!!!

ac3mark · Answer

Good Afternoon,

Insert this when the workbook sheet is changed:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim valueX
valueX = Sheet1.Range("A4")
If valueX = "4" Then
MsgBox ("your macro a here")
Else
MsgBox ("your macro b here")
End If


End Sub

Have Fun!

cprevoisin · Answer

Thank you very much! But I still have a problem.  The macro wont run...?! Do I need to make something else so it knows the value in the cell changed?

Also, is it possible to do this?

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) 
Dim valueX 
valueX = Sheet1.Range(AQ4) 
If valueX = "4" Then 
MsgBox (AlturaA) 
Else 
Dim valueX 
valueX = Sheet1.Range(AQ4) 
If valueX = "6" Then 
MsgBox (AlturaB) 
End If 

This is because I need the Macros to work with the two different values...
Thank you very much for your help!

cprevoisin · Answer

How do i save it that way?  It doesn't gives me an option.:(

Run a Macro when value is...

3 responses

Similar discussions

Subscribe To Our Newsletter!