Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

VBA what is the longest allowed name for a function or procedure

Tags:

function

max

vba

What is the maximum number of characters which can be used when assigning a name to a function (in other words, the longest allowed name for a VBA function)?

FYI, the longest allowed name for a Module is 31 (Microsoft Visual Basic 6.5 in Excel 2003).

like image 785
Genki Avatar asked Sep 03 '25 06:09

Genki


1 Answers

I just tested it - it's 255 characters...

like image 93
Peter Albert Avatar answered Sep 05 '25 01:09

Peter Albert