Load an open wb from combo box

[Beastr0]

I have a combo box and it does populate all the open workbooks I do have but now I'm trying to make it go to the selected workbook upon selection... I'm doing something wrong but can't overcome it.. this is basically what I have to load the new window

Private Sub WBList_Change()
Dim WB As Workbook
WB = WorkList.WBList.Value
Application.Workbooks(WB).Activate
End Sub

This does not work ... I know it's probably a very simple fix but my brain can't wrap around it...

 

[Andrew Poulsom]

Is it?

Private Sub WBList_Change() 
   Dim WB As Workbook 
   Set WB = Workbooks(WBList.Value)
   WB.Activate 
End Sub

 

[Beastr0]

This still gives me a type mismatch and the debugger stops @

Set WB = Workbooks(WBList.Value)

 

[Beastr0]

Hmmm.. nevermind I think I figured it out.. it was the chain of events that caused the Form to refresh and after a few cycles the value of WBList became "" and didn't work... Thanks...