Dialog Box in VBA

J

Jeff

hello,

I have the following instruction in a VBA formula:
For i = lastrow To 193 Step -1
I would like, if possible, to have a dialog box in VBA that woud read the
following:

"I = last To 193 Step -1" "Do you want to replace it ?" Then I'll need a
field that would allow me to replace it with a new "I".
Is that possible ?
Jeff
 
B

Bob Phillips

newLastRow = InputBox("I =" & lastRow & " To 193 Step -1 -- Type a new
number to replace it ?")
If newLastRow <> "" Then lastRow = newLastRow
 
Top