Trying to select from combobox to open a tab in another workbook

I have a workbook with the combobox and I want to select a month and it opens up another workbook with the correct month name. Can you tell me what I am doing wrong in my code?


With Application.Workbooks.Application.ActiveSheet

End With
For Each objWorkbook In Workbooks
ComboBox1.AddItem objWorksheet.Application.ActiveSheet


Next

Is the combobox control a form control or an ActiveX control?

Artik

Its an ActiveX control

Are you able to help me out with this