In my workbook there are numerous worksheets. I navigate between them using a combo box for the first tab (Main Menu) and command buttons on the first tab and corresponding worksheet tabs to return to a designated home position.
Here's the code for the combo box:
Private Sub cboTextFunctions_Change()
Application.Goto Range("C" & cboTextFunctions.ListIndex
This works fine the first time. The code below this returns me to the home position of the combo box. If I tried to immediately select the range I just selected nothing happens.
I have to select a different combo box option before I can return to the one I first selected. Is there a way to "refresh the combo box? I've attahced the workbook
Private Sub Home63_Click()