Fix a Missing VBA Function in Excel for Mac
Question details
The user needs a VBA user-defined function to appear in Excel’s Insert Function dialog and provide argument help.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- A standard VBA function is stored in a macro-enabled workbook and used in worksheet formulas.
- Observed behavior
- The function works when entered manually, but it does not appear in the function list or show argument-help prompts.
Open the workbook in Excel for Mac and confirm that the function works when typed in a cell. Check that the workbook is saved as a macro-enabled Excel Workbook (.xlsm).
Check the VBA function and enter it manually
Verify that the function is a standard workbook UDF, then use it in a formula while the function list issue persists.
In Excel, open the Developer tab and select Visual Basic. If the tab is hidden, enable Developer in Excel’s ribbon preferences.
In the VBA editor’s Project Explorer, find the workbook and open the standard module containing the function. Confirm that the code is not in a worksheet module, ThisWorkbook, or an add-in.
Confirm that the function is declared as a public Function rather than a Private Function, and that the module does not use Option Private Module. Save the workbook as an .xlsm file.
Return to the worksheet and type the function directly into a cell, such as =MyFunction(A1), using your function’s actual name and arguments.

Report the missing function to Microsoft
Use feedback if a correctly configured UDF works in a cell but remains absent from the function list.
Work with spreadsheets using WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for everyday spreadsheet work and an easy transition from Microsoft Office files. It does not fix Excel for Mac’s function list, and VBA compatibility may vary.

Frequently Asked Questions
Why does my VBA function work in a cell but not appear in Insert Function?
First check that it is a public Function in a standard module of the macro-enabled workbook. If it is configured correctly, the missing listing may be an Excel for Mac limitation or bug.
Where should I put a worksheet UDF in the VBA editor?
Open Developer > Visual Basic, select the workbook in Project Explorer, and place the public Function in a standard module rather than a worksheet or ThisWorkbook module.
Can I still use the function without argument-help prompts?
Yes. Type the function name and its arguments directly in a worksheet cell, such as =MyFunction(A1). Refer to the function’s VBA declaration for its argument order.
How do I report the missing function list entry?
Use Help > Feedback in Excel for Mac if available, or submit the issue through Microsoft’s Excel feedback forum. Include your Excel version and a description of how to reproduce the behavior.




