Function in VBA
 

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

Function in VBA
 

'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


"Christopher Brooks" wrote:

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

Function in VBA
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


Christopher Brooks wrote:
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

Function in VBA
 

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