Formula writing in macro

[mattyhigginsuk]

Can anyone tell me how I can get a macro to perform the following calculation please? I have absolutely no VBA knowledge, so don't know what on earth to type in!!!

F14=(1+(F11*F12/12))*F9/F12

Also, how do I get it to check that all of the other cells are present and correct? Presume if one's empty, it will just give the error message otherwise???

Thanks

 

[Andrew Poulsom]

Why do you need a macro? Can't you just enter the formula in F14?

 

[VoG]

Try like this

Sub fmla()
If Range("F12").Value <> "" Then
    Range("F14").Formula = "=(1+(F11*F12/12))*F9/F12"
Else
    Range("F14").Value = "Error"
End If
End Sub

 

[diddi]

i think he means to have it evaluated...

Sub fmla()
    If Range("F12").Value <> "" Then
        Range("F14") =(1+(range("F11") * range("F12") / 12 ) ) * range("F9") / range("F12")
    Else
        Range("F14").Value = "Error"
    End If
End Sub

i think, anyway...

 

[mattyhigginsuk]

Andrew,

I'm looking to point a button click towards the macro. I will have several buttons on the spreadsheet next to the individual variables that make up the formula, so that I can instantly solve for their value if I have changed one or more of the others.

Thanks,

Matt