Thread: UDFs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DoctorG DoctorG is offline
external usenet poster
 
Posts: 106
Default UDFs

I apologize for the naive question but I cannot seem to find documentation
(even on McRitchie's) on how to create a User Defined Function with a return
value. Pls complete the following code...

Public Sub aaaaa

if itemcheck()=true then
msgbox("ok")
else
msgbox("not ok")
endif

Public function itemcheck

if blahblah=soso then
return_value=true
else
return_value=false
endif

end function

What do I have to add to the function so that it defines the return_value
and returns it to the calling subroutine;

Thanks for your patience