Loop has goofy message all of a sudden

  • Thread starter Thread starter Revenue
  • Start date Start date
R

Revenue

I have the routine below in many spreadsheets and it has worked for a
long time up until now. When I run this macro now, I get a message as
follows:

"Code execution has been interrupted" and the options are Continue,
end, or debug. Pushing continue makes it continue until it encounters
the next Do While portion. What gives?

I've never had this before with the "Continue" option. If I choose
debug, it highlights the Loop While lines.



Sub Date_Prompt()

Do
prmo = Application.InputBox("Enter Production Month" & _
" Between 1 and 12 Inclusive)", Type:=1)

Loop While prmo < 1 Or prmo > 12
Do
pryr = Application.InputBox("Enter Production Year" & _
"Between 2000 and 2021 Inclusive)", Type:=1)
Loop While pryr < 2000 Or pryr > 2021
Range("prmo").Value = prmo
Range("pryr").Value = pryr
End Sub
 
I have the routine below in many spreadsheets and it has worked for a
long time up until now. When I run this macro now, I get a message as
follows:

"Code execution has been interrupted" and the options are Continue,
end, or debug. Pushing continue  makes it continue until it encounters
the next Do While portion. What gives?

I've never had this before with the "Continue" option. If I choose
debug, it highlights the Loop While lines.

Sub Date_Prompt()

Do
prmo = Application.InputBox("Enter Production Month" & _
  " Between 1 and 12 Inclusive)", Type:=1)

Loop While prmo < 1 Or prmo > 12
Do
pryr = Application.InputBox("Enter Production Year" & _
  "Between 2000 and 2021 Inclusive)", Type:=1)
Loop While pryr < 2000 Or pryr > 2021
Range("prmo").Value = prmo
Range("pryr").Value = pryr
End Sub
Click to expand...

What are you trying to do?
 
What are you trying to do?
Click to expand...

This macro should be asking for two variables as it has in the past.
One is a digit for the month, and obviously must be between 1 and 12.
Then, the next part validates the year as being within a range as
shown above to be between 2000 and 2021.
 
What are you trying to do?- Hide quoted text -

- Show quoted text -
Click to expand...

Now the silly thing is working properly today. Who knows sometimes
what these machines are trying to do?
 
Back
Top