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

Selecting a listbox item event
 

Get the Listbox_Click event.

--
HTH

Bob Phillips

"Todd Huttenstine" wrote in message
oups.com...
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

Selecting a listbox item event
 

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.

Selecting a listbox item event
 

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" wrote
in message
oups.com...
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