Selecting a listbox item event

Hey

I want to have a code run when a user selects any item in my listbox
(Listbox1). How can I make this happen?


Thanks
Todd Huttenstine

Get the Listbox_Click event.

--
HTH

Bob Phillips

"Todd Huttenstine" <[email protected]> wrote in message
news:[email protected]...
> Hey
>
> I want to have a code run when a user selects any item in my listbox
> (Listbox1). How can I make this happen?
>
>
> Thanks
> Todd Huttenstine
>

Assuming it's a listbox on a worksheet, then right-click on it in
design mode and select 'view code' from the context menu. That will
launch the VBA IDE and create a Listbox1_Change event procedure.

You need to use the Click event of the ListBox. E.g.,

Private Sub ListBox1_Click()
MsgBox "You clicked: " & Me.ListBox1.Value
End Sub



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Todd Huttenstine" <[email protected]> wrote
in message
news:[email protected]...
> Hey
>
> I want to have a code run when a user selects any item in my
> listbox
> (Listbox1). How can I make this happen?
>
>
> Thanks
> Todd Huttenstine
>