dropdown triggering Change event of another drop down
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?
Visual Basic Classic
8/22/2022 - Mon
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!