[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

EXcel Functions in VBA

Tony McGee

12/12/2006 5:01:00 AM

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
5 Answers

NickHK

12/12/2006 5:20:00 AM

0

Tony,
Does Option Private Module do what you need ?

NickHK

"Tony McGee" <tonym@priority1.com.au> wrote in message
news:457e378f$0$84816$c30e37c6@ken-reader.news.telstra.net...
> 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
>
>

Bob Phillips

12/12/2006 9:55:00 AM

0

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" <TungCheWah@Invalid.com> wrote in message
news:Ozo2h0aHHHA.320@TK2MSFTNGP06.phx.gbl...
> Tony,
> Does Option Private Module do what you need ?
>
> NickHK
>
> "Tony McGee" <tonym@priority1.com.au> wrote in message
> news:457e378f$0$84816$c30e37c6@ken-reader.news.telstra.net...
>> 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
>>
>>
>
>


PSL

12/13/2006 6:52:00 AM

0

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

NickHK

12/13/2006 8:32:00 AM

0

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" <PSL@discussions.microsoft.com> wrote in message
news:B02176E2-C3A9-4A35-8A42-535C0E96D329@microsoft.com...
> 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

Bob Phillips

12/13/2006 9:21:00 AM

0

Maybe extend this

=CHOOSE(A1-122,"Pen","Paper")

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"PSL" <PSL@discussions.microsoft.com> wrote in message
news:B02176E2-C3A9-4A35-8A42-535C0E96D329@microsoft.com...
> 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