Function in VBA

[Christopher Brooks]

When I write a function into any of the Excell objects in
VBA as follows:

Function Bird()
End Function

then type

=Bird()

into the spread sheet, it does not see the function.

When I debug the function, I get the following error
message:

Object library invalid or contains references to object
definitions that could not be found.

What is going on here? Isn't a function supposed to work
in the spreadsheet?

-cnb

 

[keepITcool]

'any of the excel objects' is crucial here...
these are 'object modules' and work differently from normal code modules

insert a standard module.
type or copy your code there

et voila!





keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Frank Kabel]

Hi Christopher
you have probably inserted this piece of code in a workbook or
worksheet module instead of a standard module

 

[Christopher Brooks]

-----Original Message-----
'any of the excel objects' is crucial here...
these are 'object modules' and work differently from normal code modules

insert a standard module.
type or copy your code there

et voila!

et voila, indeed! Thank you very much. I have the feeling
that I may be returning to this forum.

-cnb