VBA excel combobox.dropdown method only woks with every other box -
i have form 3 comboboxes. when run wish able cycle through them using tab key , when each box has focus list drop down automatically (so don't have press down arrow). in form code have following private sub combobox1_enter() combobox1.dropdown end sub with same combobox 2 & 3 however work every other box. on initial run, combobox1 has focus - no drop down appears. press tab & combobox2 gets focus , dropdown appears. press again cpmbobox3 gets focus - no dropdown. press again combobox1 takes focus again , dropdown list apears , on, if click on box, list dropdown. if put object such text box in between each combobox dropdown method work each combobox. any 1 ideas why dropdown method won't work consecutive comboboxes when using tab? yes happens because tabing interferes normal functioning. try (tried , tested ) logic : capture tab key (keycode: 9) , set 0 , move next combo using code. code : option explicit dim long '~~> adding s...