Practice free

REGISTER.ID function

REGISTER.ID registers an external routine and returns an ID that CALL can use to run it. It is a legacy Excel 4 macro-sheet function that works on Windows only and is often blocked.

Example

=REGISTER.ID("Kernel32","GetTickCount","J")

Expected result: n/a Not yet checked in desktop Excel

Syntax

REGISTER.ID(module_text, procedure, [type_text])

Arguments in [square brackets] are optional.

module_text (required)
Name of the DLL or code resource.
procedure (required)
Name of the function inside it.
type_text (optional)
Codes describing the argument and return types.

Returns: A registration ID to pass to CALL.

Watch out for

  • Returns #VALUE! if the DLL or routine is not found.

Where it works

Excel
REGISTER.ID is in every version of Excel from 2007 on. Legacy Excel 4 macro function; Windows only and often blocked.
Google Sheets
No direct equivalent. No counterpart.

Part of Add-in and automation functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .