Thread: Excel Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dhstein dhstein is offline
external usenet poster
 
Posts: 266
Default Excel Function

I'm trying to write a User Defined Function and need the VB syntax to refer
to the cell. For example if my function is called func1 and I put the
formula =func1(B2) in my spreadsheet, I want to manipulate the contents of B2
in my function.

I need something like:

Function func1(Entry As Long)
Addr = Application.Caller.Address

func1 = Addr.Contents
End Function

I need some syntax help here and some basic VB instruction - I know enough
programming to be dangerous - I just need a little start. Is there a web
site I can refer to? Thanks for any help.