| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to assign a Category to a custom function?
When you bring up the function wizard, you can select functions by Category
(Financial, Date & Time, Database, Text, etc). How does one assign a Category to their custom (VBA created) function so it will show up in the appropriate Category? -- Toby Erkson http://www.bidata.net/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to assign a Category to a custom function?
Toby,
Categories... ' 0 = All 11 = Customizing ' 1 = Financial 12 = Macro Control ' 2 = Date & Time 13 = DDE/External ' 3 = Math & Trig 14 = User Defined ' 4 = Statistical 15 = Engineering ' 5 = Lookup & Reference ' 6 = Database ' 7 = Text ' 8 = Logical ' 9 = Information ' 10 = Commands Private Sub ShouldBeFunctionCategories() Application.MacroOptions macro:="Bootstraps", Category:=5 Application.MacroOptions macro:="Mushrooms", Category:=10 Application.MacroOptions macro:="TheRightThing", Category:=8 End Sub -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Toby Erkson" <t o b y e a t b i d a t a d o t n e t wrote in message When you bring up the function wizard, you can select functions by Category (Financial, Date & Time, Database, Text, etc). How does one assign a Category to their custom (VBA created) function so it will show up in the appropriate Category? -- Toby Erkson http://www.bidata.net/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to assign a Category to a custom function?
Thank you Jim, works perfectly!!
P.S. Go Beavers! ;-) My brother-in-law is a Duck fan...it's true you can't pick your relatives :-D -- Toby Erkson http://www.bidata.net/ "Jim Cone" wrote in message ... Toby, Categories... ' 0 = All 11 = Customizing ' 1 = Financial 12 = Macro Control ' 2 = Date & Time 13 = DDE/External ' 3 = Math & Trig 14 = User Defined ' 4 = Statistical 15 = Engineering ' 5 = Lookup & Reference ' 6 = Database ' 7 = Text ' 8 = Logical ' 9 = Information ' 10 = Commands Private Sub ShouldBeFunctionCategories() Application.MacroOptions macro:="Bootstraps", Category:=5 Application.MacroOptions macro:="Mushrooms", Category:=10 Application.MacroOptions macro:="TheRightThing", Category:=8 End Sub -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to assign a Category to a custom function?
Toby,
You are welcome. Oregon State was the last major college football team to give up Single Wing football. They haven't been the same since. <g Regards, Jim Cone "Toby Erkson" <t o b y e a t b i d a t a d o t n e t wrote in message ... Thank you Jim, works perfectly!! P.S. Go Beavers! ;-) My brother-in-law is a Duck fan...it's true you can't pick your relatives :-D -- Toby Erkson http://www.bidata.net/ "Jim Cone" wrote in message ... Toby, Categories... ' 0 = All 11 = Customizing ' 1 = Financial 12 = Macro Control ' 2 = Date & Time 13 = DDE/External ' 3 = Math & Trig 14 = User Defined ' 4 = Statistical 15 = Engineering ' 5 = Lookup & Reference ' 6 = Database ' 7 = Text ' 8 = Logical ' 9 = Information ' 10 = Commands Private Sub ShouldBeFunctionCategories() Application.MacroOptions macro:="Bootstraps", Category:=5 Application.MacroOptions macro:="Mushrooms", Category:=10 Application.MacroOptions macro:="TheRightThing", Category:=8 End Sub -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to assign a Category to a custom function?
Categories 0-10 are standard and stable, but subsequent categories are added
by various applications/add-ins and will vary (both the names and the order in which they occur) from PC to PC. Jerry "Jim Cone" wrote: Toby, Categories... ' 0 = All 11 = Customizing ' 1 = Financial 12 = Macro Control ' 2 = Date & Time 13 = DDE/External ' 3 = Math & Trig 14 = User Defined ' 4 = Statistical 15 = Engineering ' 5 = Lookup & Reference ' 6 = Database ' 7 = Text ' 8 = Logical ' 9 = Information ' 10 = Commands Private Sub ShouldBeFunctionCategories() Application.MacroOptions macro:="Bootstraps", Category:=5 Application.MacroOptions macro:="Mushrooms", Category:=10 Application.MacroOptions macro:="TheRightThing", Category:=8 End Sub -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Toby Erkson" <t o b y e a t b i d a t a d o t n e t wrote in message When you bring up the function wizard, you can select functions by Category (Financial, Date & Time, Database, Text, etc). How does one assign a Category to their custom (VBA created) function so it will show up in the appropriate Category? -- Toby Erkson http://www.bidata.net/ |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to assign a Category to a custom function?
Jerry,
Thanks for the information. I'll take your word for it. I haven't assigned categories to functions in 5 or 6 years. I think User Defined is more meaningful to most users anyway. Regards, Jim Cone San Francisco, USA "Jerry W. Lewis" wrote in message Categories 0-10 are standard and stable, but subsequent categories are added by various applications/add-ins and will vary (both the names and the order in which they occur) from PC to PC. Jerry "Jim Cone" wrote: Toby, Categories... ' 0 = All 11 = Customizing ' 1 = Financial 12 = Macro Control ' 2 = Date & Time 13 = DDE/External ' 3 = Math & Trig 14 = User Defined ' 4 = Statistical 15 = Engineering ' 5 = Lookup & Reference ' 6 = Database ' 7 = Text ' 8 = Logical ' 9 = Information ' 10 = Commands Private Sub ShouldBeFunctionCategories() Application.MacroOptions macro:="Bootstraps", Category:=5 Application.MacroOptions macro:="Mushrooms", Category:=10 Application.MacroOptions macro:="TheRightThing", Category:=8 End Sub -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Toby Erkson" <t o b y e a t b i d a t a d o t n e t wrote in message When you bring up the function wizard, you can select functions by Category (Financial, Date & Time, Database, Text, etc). How does one assign a Category to their custom (VBA created) function so it will show up in the appropriate Category? -- Toby Erkson http://www.bidata.net/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a custom cell format category? | Excel Worksheet Functions | |||
| How do I make a custom category axis? | Charts and Charting in Excel | |||
| Add a category to the Insert-Function category list | Excel Programming | |||
| Assign Sub to Custom Button | Excel Programming | |||
Hybrid Mode
