A Code pause and resume and to change a cell value based on another cell..HELP?

Hi every one..
im new here..and im also new to excel VBA.. i have some question and hope i find the answers here.
so without getting into much unnecessary details:

1) i want for example in cell A1 the user with enter a Grade No. from 1 to 100..i want the text in cell B1 to change accordingly to a grade!!
if A1 = 1-50 i want the text in B1 to be "the score is (A1 value) and this means the student failed"
if A1=51-70 then B1= "the score is (A1 value) and this means the student is good"
if A1= 71-90 then B1= "the score is (A1 value) and this means the student is very good"
if A1=91-100 the B1= "the score is (A1 value) and this means the student is excellent"
So thats the easy Question

2) the hard 1 is: is it possible to pause a sub in the middle to ask the user if he wants to enter some data in worksheet manually and if he says YES then it activate this sheet and allow him to enter data.. then when hes finished he can click a button to resume the sub where it stopped till the end of the sub and to the next sub.
However if the user didn't want to enter data manually he can click NO then it jumps to the next sub directly..

this is a tricky hard 1, huh?? but i think i'll find my answer here

Honestly i did expect that i'll find the answer here...
what i didn't expect is, having it so fast..
so even before i check if the codes work and i'm sure they will..just wanna say thanks very much..