Using a Macro as a Function Called From Cell to Populate a Cell Value

Using a Macro as a Function Called From Cell to Populate a Cell Value

I'm trying to populate individual cells with  function calls to a macro similar to how one would use a regular function to populate a cell. My function is:

Public Function getHours(item As String,high As Number) As Double
    Sheets("Work Items").Select
    numRows = ActiveSheet.Rows
    getHours = 0

    For i = 2 To numRows
        if Cells(i,2).value= item Then
            if high = 1 Then   
                getHours = getHours + Cells(i,6).value
            else
                getHours = getHours + Cells(i,5).value
            end if
          end if
    Next i
End Function      

Where I pass a cell value and constant to return a double. However, whenever I try to use the function, it doesn't come up as an option when I type = into the cell, and when I type out the arguments like "=getHours(a3,0)", it re-formats to "=GETHOURS(A3;0)" and gives me a #NAME! error. Even if my code isn't correct, it doesn't seem like using macros in this fashion even works in Sheet.

My function doesn't show up on the manage tab for macros, but when I try to create a new macro with the same name it says that it already exists.

If using a macro isn't possible, could I be assisted with an alternative method?

Thanks.




      • Sticky Posts

      • Slicers are now available in Zoho Sheet—filter your data interactively

        At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,

      • Check out the new Checkbox in Zoho Sheet

        Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the Format

      • Format and analyze spreadsheet data with Zoho Sheet's Table

        While a spreadsheet helps you compile data for easy analysis, formatting helps make your data more comprehensible. We are happy to announce the release of Table, a crucial tool for improving data formatting in Zoho Sheet. More than a formatting tool,

      • Introducing Data Bars: Graphically represent changes in data within the cells

        Conditional formatting has helped millions of spreadsheet users analyze and highlight their data more efficiently. In addition to the classic rules, color scales, and icon sets available in Zoho Sheet, you can now apply Data Bars, a convenient method

      • Zia in Zoho Sheet now makes suggestions on conditional formats, picklists, and checkboxes

        Zia, Zoho's popular AI assistant, has been helping users succeed across Zoho applications since inception. In Zoho Sheet, Zia helps users efficiently build reports and analyze data with recommendations about data cleaning, charts, and pivot table. Also,