Help Transitioning Formula to VBA

[wakefield101]

Could someone please help me translating the formula below into VBA coding? I would like if all of these cells were pre-populated behind the scenes.

=IF(SUMIF($T$12:$SF$12,"<="&EOMONTH(V$12,0),$T14:$SF14)<=$K14,V14*$J14,(SUMIF($T$12:$SF$12,"<="&EOMONTH(V$12,0),$T14:$SF14)*J14)-$I227)

My range is: T226:SF235

Thanks!!