Pass a form Listbox as an object

[Brian]

I'm trying to pass a vba forms listbox as an object.

Scenario: I have a form with two populated listboxes. When I click on one,
I want to perform an action based on the value selected. The action is
independent of which listbox is selected, but needs to know somethings about
the listbox activated.

How do I pass the listbox object as an argument?

Thanks for the help.
Brian

[Bob Phillips]

Brian,

This example should show you

Private Sub ListBox1_Click()
WhichListbox Me.ListBox1
End Sub

Private Sub ListBox2_Click()
WhichListbox Me.ListBox2
End Sub

Sub WhichListbox(LB As msforms.ListBox)
MsgBox LB.Name
End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brian" <[email protected]> wrote in message
news:[email protected]...
> I'm trying to pass a vba forms listbox as an object.
>
> Scenario: I have a form with two populated listboxes. When I click on
one,
> I want to perform an action based on the value selected. The action is
> independent of which listbox is selected, but needs to know somethings
about
> the listbox activated.
>
> How do I pass the listbox object as an argument?
>
> Thanks for the help.
> Brian
>
>

[Brian]

That was it!!!

Thanks,

Funny thing is my test code was doing just what you demonstrated...
msgbox-ing the lb name.

Anyway.... I'll remember this one.

B



"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> Brian,
>
> This example should show you
>
> Private Sub ListBox1_Click()
> WhichListbox Me.ListBox1
> End Sub
>
> Private Sub ListBox2_Click()
> WhichListbox Me.ListBox2
> End Sub
>
> Sub WhichListbox(LB As msforms.ListBox)
> MsgBox LB.Name
> End Sub
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Brian" <[email protected]> wrote in message
> news:[email protected]...
> > I'm trying to pass a vba forms listbox as an object.
> >
> > Scenario: I have a form with two populated listboxes. When I click on
> one,
> > I want to perform an action based on the value selected. The action is
> > independent of which listbox is selected, but needs to know somethings
> about
> > the listbox activated.
> >
> > How do I pass the listbox object as an argument?
> >
> > Thanks for the help.
> > Brian
> >
> >
>
>