FG
💻 Software

Where to find a VBA function's source in Excel

Fresh7 days ago
Mar 15, 202664715 views
Confidence Score0%
0%

Problem

I have a workbook that uses a certain vba function which doesn't appear in the Insert | Insert Function... dialog box list of available functions. How do I find it's source (to see what it does)?

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Where to find a VBA function's source in Excel

Low Risk

I hope I understand your question... From reading other answers I see that it is not a recorded macro. It's safe to assume then that someone wrote it in VBA. Try the following: Press Alt+F11 to open your VBA editor Click View -> Project Explorer (it…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment