Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXcel Functions in VBA
I have written an addin which amongst other things has some custom functions
available for general use (under the User Defined Category) once the addin is installed. However, I also have some functions I would only like available for use by my VBA code. Is there any way I can make these functions "publically available" to all of my code, but NOT appearing in the Excel Insert Function list. Thanks Tony McGee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXcel Functions in VBA
Tony,
Does Option Private Module do what you need ? NickHK "Tony McGee" wrote in message ... I have written an addin which amongst other things has some custom functions available for general use (under the User Defined Category) once the addin is installed. However, I also have some functions I would only like available for use by my VBA code. Is there any way I can make these functions "publically available" to all of my code, but NOT appearing in the Excel Insert Function list. Thanks Tony McGee |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXcel Functions in VBA
To add to Nick's response, you would put those functions in a separate
module, you wouldn't want to Option Private to apply to the other truly Public functions. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "NickHK" wrote in message ... Tony, Does Option Private Module do what you need ? NickHK "Tony McGee" wrote in message ... I have written an addin which amongst other things has some custom functions available for general use (under the User Defined Category) once the addin is installed. However, I also have some functions I would only like available for use by my VBA code. Is there any way I can make these functions "publically available" to all of my code, but NOT appearing in the Excel Insert Function list. Thanks Tony McGee |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF Function
Hi,
Could u please help me on the following issue: If I given item code in A1 as 123 then B1 should display as "PEN": I need to execute the Item Name in a cell B1 when I enter the Item Code in A1. Examples: ------------ If I given item code in A1 as 123 then B1 should display as "PEN" If I given item code in A2 as 124 then B2 should display as "PAPER" Like this I have 18 Item Code were there. Please help on this. Thank You, PSL |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF Function
You should start a new thread, as this has nothing to do with the OP's
question. Anyway, sounds like you need VLOOKUP. NickHK "PSL" wrote in message ... Hi, Could u please help me on the following issue: If I given item code in A1 as 123 then B1 should display as "PEN": I need to execute the Item Name in a cell B1 when I enter the Item Code in A1. Examples: ------------ If I given item code in A1 as 123 then B1 should display as "PEN" If I given item code in A2 as 124 then B2 should display as "PAPER" Like this I have 18 Item Code were there. Please help on this. Thank You, PSL |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF Function
Maybe extend this
=CHOOSE(A1-122,"Pen","Paper") -- --- HTH Bob (change the xxxx to gmail if mailing direct) "PSL" wrote in message ... Hi, Could u please help me on the following issue: If I given item code in A1 as 123 then B1 should display as "PEN": I need to execute the Item Name in a cell B1 when I enter the Item Code in A1. Examples: ------------ If I given item code in A1 as 123 then B1 should display as "PEN" If I given item code in A2 as 124 then B2 should display as "PAPER" Like this I have 18 Item Code were there. Please help on this. Thank You, PSL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Conversion from Spreadsheet Toolkit functions (ESSV....) to EssBase API functions | Excel Programming | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
excel functions and User defined functions | Excel Programming |