View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Passing a Forms Control to Function

as an example


Function myFunc(lb As MSForms.ListBox)
MsgBox lb.Value
End Function


and in the form

myFunc Me.ListBox1


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Pflugs" wrote in message
...
I want to write a function that checks a listbox for an entry and reports
true or false. I want the input to be the listbox to check and the

potential
entry. How do I pass the listbox to the function?

Thanks,
Pflugs