VBA Script not getting trigger for automatic calculation

Or try maybe this code:

1. UserForm1 module:

Option Explicit

Private Sub UserForm_Initialize()
    With UserForm1
        .Caption = "Test window"
        .DropDown1.List() = Array("1", "2", "3") 'Testing for 3 sheets
    End With
End Sub

Private Sub DropDown1_Change()
    With UserForm1.DropDown1
        If .Value = ActiveSheet.Name Then Exit Sub
        Call combo_execute(.Value)
    End With
End Sub

Private Sub combo_execute(shtName As String)
    Sheets(shtName).Visible = True
    ActiveSheet.Visible = False
    Application.GoTo Reference:=ActiveSheet.Range("a1"), Scroll:=True
End Sub

Before you run the macro, hide sheets except one with any name (of course, one in the names range of your sheets).

Dear Experts, The combobox is still the same after opening the workbook it works for 2 or 3 changes then it stucks then for every selection change i need to click on calculate now. Please help me.

???
A small change in the code:
(see attachment)

Option Explicit

Private Sub UserForm_Initialize()
    With UserForm1
        .Caption = "Test window"
        .DropDown1.List() = Array("1", "2", "3") 'Testing for 3 sheets
    End With
End Sub

Private Sub DropDown1_Change()
    With UserForm1.DropDown1
        If .Value = "" Then Exit Sub 'A small change in the code here
        If .Value = ActiveSheet.Name Then Exit Sub
        Call combo_execute(.Value)
    End With
End Sub

Private Sub combo_execute(shtName As String)
    Sheets(shtName).Visible = True
    ActiveSheet.Visible = False
    Application.GoTo Reference:=ActiveSheet.Range("a1"), Scroll:=True
End Sub

Hi porucha vevrku, Thank you for your support. I do have combobox with list of 22 files for go to the selected worksheet and hide the rest but the provided solution here is for the userform. So do i need to create the userform for the 22 worksheet list.

Dear expert based on provided range criteria can you please create a sample workbook with userfom and script .

And the range is given for combo box from sheet2 cell AC2:AC24.

Dear Expert TMS, as I am not familiar with the VBA so that is only reason to create a sample workbook with the script because I was completely not getting how to use userform in workbook as dropdown for selecting the worksheet.

I do apologise for the same. I would surely take care of henceforth.

1.

Originally Posted by Neilesh Kumar

...combobox with list of 22 files ... 22 worksheet list.

Originally Posted by Neilesh Kumar

...from sheet2 cell AC2:AC24

From "ac2" to "ac24" there are 23 sheets

2. Continuing with Keebellah's corrections to my corrections to your corrections to your corrections of our corrections, etc.
... : ( ... : | ... : () ... : ) ... : )) ... :

You have now enough code, to do something yourself ... : ) ...