Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop to the next row
I have the following code done. The user wants to be able to push the "Flat"
button as many times as needed to add more information. Every time I loop it I rewrite over my initial data. How do I make it skip down to the next row? Also I want the user to have to choose yes or no to continue to loop. Private Sub Flat_Click() Dim sreturn As String sreturn = InputBox("Enter start date dd/mm/yyyy 24hr clock") [A11] = sreturn sreturn = InputBox("Enter stop date dd/mm/yyyy 24hr clock") [B11] = sreturn sreturn = InputBox("Enter TSN to increase") [C11] = sreturn sreturn = InputBox("Enter TSN to decrease") [D11] = sreturn sreturn = InputBox("Enter MW Amount") [E11] = sreturn End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find loop doesn't loop | Excel Discussion (Misc queries) | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
Loop Function unable to loop | Excel Programming | |||
Problem adding charts using Do-Loop Until loop | Excel Programming | |||
HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming |