macro calling a function

[JAYLO]

I have the following function..
=SUMIF(C:C,31,D:D)/COUNTIF(C:C,31)
I need to call it from a macro and display results in a vb text box.

TIA
Jay

 

[Jay Petrulis]

On 2002-04-04 15:54, JAYLO wrote:
I have the following function..
=SUMIF(C:C,31,D:D)/COUNTIF(C:C,31)
I need to call it from a macro and display results in a vb text box.

TIA
Jay

Hi JayLo,

The following worked for me when placed in the userform initialize event

--------------
Private Sub UserForm_Initialize()

With ThisWorkbook.Sheets("Sheet1")
UserForm1.TextBox1.Value = Evaluate("=SUMIF(C:C,31,D:D)/COUNTIF(C:C,31)")
End With

End Sub
--------------

Modify to suit your workbook/sheets/range

HTH,
Jay