VBA功能未显示或无法正常工作 [英] VBA Function is not showing up nor is it working

问题描述

请看；我的简单VBA功能没有显示:

Please look; my simple VBA function is not showing up:

Function master(sega)
    master(sega) = WorksheetFunction.SumIf([sega], "<80")
End Function

推荐答案

Sub SumifTest()

Dim ws As Worksheet

Set ws = ThisWorkbook.Worksheets("sheet1")

Dim Rng As Range
Set Rng = ws.Range("A:C")

Dim x As Double

x = Master(Rng)
    Debug.Print x

End Sub


Function Master(Sega As Range)

    Master = Application.WorksheetFunction.SumIf(Sega, "< 80")

End Function

这篇关于VBA功能未显示或无法正常工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！