Dialog Box in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

defined sheet formula to vb code 2
excel vba option dialog box 2
Excel VBA 1
Macro Dialog Box 1
coloring cells that contain formula 5
How can I loop through a the values in multiple rows 6
VBA Code User Range Selection 5
Annoying Replace Dialog Box 2

Back
Top