Min If with Excel VBA

I am trying to understand how I can code in VBA the equivalent of an array Min If formula.

I need to find the minimum value of a column when certain conditions in other columns are met based on parameters in each row.

I was able to do so using a bracket formula in Excel, but I can't replicate it using VBA code.

What function should I use? Thanks!