click event on listbox

  • Thread starter Thread starter CStephenson
  • Start date Start date
C

CStephenson

I have 5 listboxes when I do a click event on one of them this causes the
macros on all listboxs to run one after other?
 
I am assuming your list boxes are in a sheet and that you created them using
data validation? My code here assumes the list boxes are in cells A1, B1 and
C1. You can modify this for 5 list boxes placed where ever.

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$A$1"
MsgBox Target.Value
Case "$B$1"
MsgBox Target.Value
Case "$C$1"
MsgBox Target.Value
End Select

End Sub

If my assumptions are inccorect then let me know and post your code with the
reply...

HTH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Close na "on the fly" created Listbox if ignored by the user? 1
listbox click event question 4
Multi listbox change event - selected or deselected 6
Application.enableevents = false not working in workbook open even 5
Multi-select listbox - mousedown event 2
Listbox Problem 1
Set Cell value form ListBox. 4
Multiselect on Listbox and Click Event 1

Back
Top