Example 1
Jump out of the input from there, the user enters C1 in the input window, then jumps out of the input window and enters C10, then jumps out of the input window and enters the interval, and enters 2, so EXCEL VBA will display C1 in A1, then C2 in A4, and then in A7, present C3, then at A10, presented C4, then at A13, presented C5, then at A16, presented C6, then at A19, presented C7, then at A22, presented C8, then at A25, presented C9, then at A28, presented C10
Example 2
Jump out of the input from there, the user enters D1 in the input window, then jumps out of the input window and enters D5, then jumps out of the input window and enters the interval, and enters 1, so EXCEL VBA will display D1 in A1, then D2 in A3, and then in A5, render D3, then at A7, renders D4, then at A9, renders D5
Example 3
From there, the user enters Y1 in the input window, enters Y5 in the input window, enters the interval in the input window, and enters 3, so EXCEL VBA will display Y1 in A1, then Y2 in A5, and then A9 , presenting Y3, then at A13, presents Y4, then at A17, presents Y5
CODE NOT COMPLETE , I don't know how to write it. One code can complete three different tasks in examples
Sub FillData()
Dim startValue As String
Dim endValue As String
Dim increment As Integer
Dim cell As Range
Dim rowIndex As Integer
startValue = InputBox("Please enter a starting value ")
endValue = InputBox("Please enter an ending value ")
increment = InputBox("Please enter the interval ")
rowIndex = 1
?????????
Next cell
end sub
Any help would be greatly appreciated!
Bookmarks