In your Worksheet_Change() event, add the following If statement:
Sub Worksheet_Change()
if cboIssues.ListIndex = 1 then
' your existing code here
end if
end Sub
This will trigger the event only when the index is 1. Or put <>1 if you need the oposit thing to happen.
- Mangesh
Bookmarks