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 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
"CStephenson" wrote:
> 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?
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks