Taking input from InputBox from user

[SeattleITguy]

Hello Everyone!



I want to take the text inputted from the user from the InputBox below and use that text as something to call on in the following IF statement.

The IF statement part of the code will filter different items depending on what the user inputs. I can provide that code if it helps give a better idea what I am trying to achieve.

(Forgive me if my post is incomplete/missing data/erroneous as I am very tired)

Sub wtf()

    BeginRow = 1
    EndRow = 120
    CUSTOMER = 18

InputMsg = "Which view would you like to use"
InputTitle = "Filter View"
DefaultText = "Management"
SpreadsheetTitle = InputBox(InputMsg, InputTitle, DefaultText)
ActiveCell.FormulaR1C1 = "Management"

msgbox (SpreadsheetTitle)

        If SpreadsheetTitle = "CUSTOMER" Then
            msgbox ("CUSTOMERZOR")
        Else
            msgbox ("Not CUSTOMER")
        End If


End Sub

Please let me know if I can provide any further info!

Cheers!

[SeattleITguy]

Figured out the issue myself.

The variable

SpreadsheetTitle

was the variable I needed.