troubleshooting Question

dropdown triggering Change event of another drop down

Avatar of iderskater
iderskater asked on
Visual Basic Classic
4 Comments1 Solution163 ViewsLast Modified:
Hey everyone...

I'm working with VBA within Excel and I have a worksheet with two dropdowns/combo boxes on it.  One lists the sales regions (cbx_region) and another that gets populated with sales reps depending on which region you select (cbx_rep).  So I have a Sub call in the cbx_region Change event that updates the list in cbx_rep, and selects the first item in the list.  My problem is that it works fine when I change the sales region, but for some reason the cbx_region_Change() event gets called when I select a sales rep from the cbx_rep combobox.  And this is screwing up my selection because no matter what I choose from cbx_rep it selects the first rep in the list.  Any clues to why this would be?
ASKER CERTIFIED SOLUTION
GrahamSkan
Retired
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros