VBA & Macro Problems

Fix a Missing VBA Function in Excel for Mac

Phi Hung VoPhi Hung Vo Nov 20, 2026 868 views

Question details

The user needs a VBA user-defined function to appear in Excel’s Insert Function dialog and provide argument help.

Fix a Missing VBA Function in Excel for Mac
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.
Before you start

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).

Solution 1Recommended

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.

1
Open the VBA editor

In Excel, open the Developer tab and select Visual Basic. If the tab is hidden, enable Developer in Excel’s ribbon preferences.

2
Inspect the module

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.

3
Check the declaration

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.

4
Enter the formula

Return to the worksheet and type the function directly into a cell, such as =MyFunction(A1), using your function’s actual name and arguments.

Check the VBA function and enter it manually
Function list behavior: These checks do not guarantee that the UDF will appear in Insert Function or display argument prompts. The behavior may be a limitation or bug in Excel for Mac.
Free Microsoft Office alternative

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.

Create formulas and work with spreadsheet data in a familiar interface.Open and edit Microsoft Excel formats such as .xlsx.Use a free, lightweight suite for everyday Office tasks.
microsoft office alternative - wps office

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.