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)
Code:
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!