User input to select a specific sheet upon opening

[email protected] · May 18th 2020

I need a macro that will ask an end user which sheet they want to open up and input data to. The difference between sheets if the type of Quote they are doing, such as a service quote or an estimate. Hope that makes sense.

dangelor · May 18th 2020

Possibly...

Code

Sub ChooseWorksheet()
    Dim ws As Worksheet, sList As String, sName As String

    For Each ws In ThisWorkbook.Worksheets
        sList = sList & vbCrLf & ws.Name
    Next ws
    sName = Application.InputBox("Type in a worksheet name from this list:" & _
            vbCrLf & sList, "Worksheet Choice" & vbCrLf, , 25, 25, , , 2)
    MsgBox "You chose" & vbCrLf & vbCrLf & sName
    
End Sub

Display More

**royUK** · May 19th 2020

I would suggest a ListBox that lists the sheets for the user to select from

[email protected] · Jun 11th 2020

dangelor,

I am getting a an error.

dangelor · Jun 11th 2020

You're missing a " _" (space & underscore) at the end of the previous line. It's needed to tell the complier that the 2 lines are just 1 line.

User input to select a specific sheet upon opening

Participate now!

Share

Tags