Skip Macro with IF Condition

[earthworm]

If i want to skip one macro if the value in cell for example A1 is 0 then move to next macro .

How can i do this. I am not sharing any example because i only want to understand the formula construction

 

[jasonb75]

Something like

If Range("A1").Value = 0 Then
    Call Macro2
Else
    Call Macro1
End If

Should do it. For more than 2 options, take a look at Select Case as an alternative method.

 

[earthworm]

select case ?

 

[earthworm]

If the value in cell B3 is 0 then i want macro to write value in cell E3 as B and if value in cell B3 is >0 then i want macro to write value in cell E3 as A

Sub Macro3()'
' Macro3 Macro
'


'
    ActiveCell.FormulaR1C1 = "A"
    Range("E3").Select
    ActiveWindow.SmallScroll Down:=-6
    ActiveCell.FormulaR1C1 = "b"
    Range("E3").Select
End Sub

I am writing a simple macro to clear my understanding . please help

 

[jasonb75]

See the example here https://docs.microsoft.com/en-us/do...ge-reference/statements/select-case-statement

edit:- for something as simple as you mention above you don't need a macro, just a simple formula =IF(B3=0,"B","A")