Thread: Function in VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Christopher Brooks Christopher Brooks is offline
external usenet poster
 
Posts: 1
Default 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