Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User-defined function with a naming format of =ABC.XYZ.
Is there a way to create an user-defined function in Excel
2000/2002 with a naming format of =ABC.XYZ(...)? I see Microsoft provides a couple of functions ERROR.TYPE and REGISTER.ID natively in Excel. I'm unable to do this using VBA in Excel. Is there some other route I can adopt to accomplish this? Thanks much, Vipul Parekh |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User-defined function with a naming format of =ABC.XYZ.
Vipul Parekh -
Is there a way to create an user-defined function in Excel 2000/2002 with a naming format of =ABC.XYZ(...)? < I don't think so. Excel 2002 VBA Help says "Name of the Function; follows standard variable naming conventions." and "Visual Basic Naming Rules ... You can't use a space, period (.), exclamation mark (!), or the characters @, &, $, # in the name." - Mike Middleton |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
user defined function | Excel Worksheet Functions | |||
user defined functions format | Excel Discussion (Misc queries) | |||
Custom Format for User Defined Function | Excel Discussion (Misc queries) | |||
User defined function | New Users to Excel | |||
user defined function | Excel Worksheet Functions |