I have two ComboBoxes each being loaded(ListFillRange) by spearate information in named ranges(ex. "benny" referes to i.e. c1:c25 loades Combobox1, etc.) on the excel sheet. This populates the box and allows the user to click on the item within the ComboBox. This item is associated with the click event which when selected opens the workbook associated with this item. My problem is that whenever the user selects a file,the associated workbook is opened, but this causes my sub to restart from the beginning. Which is not too bad since it basically tries to open the file again. However, it then jumps to the second combobox click even. The user hasn't done anything and I can't figure out why it is jumping from one sub to another when nothing has changed. any insight?