VBA dynamic UserForm conrols: how to find out is worksheet exists

To check if a worksheet exists in Excel using VBA and create it if it doesn't, you can use the following code:

VBA

Sub CheckAndCreateWorksheet()
    Dim ws As Worksheet
    Dim wsName As String
    
    wsName = "Sheet2"

    On Error Resume Next
    Set ws = Worksheets(wsName)
    On Error GoTo 0
    
    If ws Is Nothing Then
        Worksheets.Add(After:=Worksheets(Worksheets.Count)).Name = wsName
        MsgBox "Worksheet '" & wsName & "' created."
    Else
        MsgBox "Worksheet '" & wsName & "' already exists."
    End If
End Sub

In this example, we're checking if a worksheet named "Sheet2" exists. You can change the wsName variable to the name of the worksheet you want to check. If the worksheet doesn't exist, it will be created using Worksheets.Add method, and if it already exists, a message box will be displayed indicating that it already exists.