Hey Guys ! The code is so simple (I thought...) but it isn't even displaying the input box, and I've never encountered that. I have some code before the issue to give some variables names:
ActiveWorkbook.Sheets(1).Select
sheett1 = ActiveSheet.Name
ActiveWorkbook.Sheets(2).Select
sheett2 = ActiveSheet.Name
ActiveWorkbook.Sheets(3).Select
sheett3 = ActiveSheet.Name
ActiveWorkbook.Sheets(4).Select
sheett4 = ActiveSheet.Name
ActiveWorkbook.Sheets(5).Select
sheett5 = ActiveSheet.Name
ActiveWorkbook.Sheets(6).Select
sheett6 = ActiveSheet.Name
and then that works fine, but when I try to use:
PrelimOrFinal = Application.InputBox _
(Prompt:="Which sheet would you like to process? (Pick one of the 'Translated' sheets)" & vbNewLine & _
"1 - " & sheett1 & vbNewLine & _
"2 - " & sheett2 & vbNewLine & _
"3 - " & sheett3 & vbNewLine & _
"4 - " & sheett4 & vbNewLine & _
"5 - " & sheett5 & vbNewLine & _
"6 - " & sheett6 & vbNewLine & _
vbNewLine & _
"Please insert a line number that corresponds with a worksheet.", Title:="Which sheet?", Type:=1)
On Error GoTo errnoentry
Application.DisplayAlerts = True
It doesn't display the box and just says that Prelimorfinal = "Error 2015" I'm still really new to this stuff and I thought I would try to break down the code into multiple lines so it's prettier and I undid that as an experiment but that doesn't appear to be the problem.
I'm pretty sure I made a dumb error. But I've tried Googling this and I just have no idea what went wrong.
(The code is posted virtually in entirety, I omitted a line that checks for worksheets.count = 6 at the very top, and I split it up because I'm trying to identify that the top portion works fine and the problem is 'only' in the bottom portion)
Bookmarks