Hello all,
so I have a table to enter data, seven columns... I have wrote a command button with a inputbox code.
so basicly what I do is.. I click the command button and it asks me to fill the data from cell A2 to G2.
what I need is that after I fill data on G2, I need to repeat the whole process on the next row which means from A3 to G3 and so on.... in other words I need the code to reach column G then go back to column A but in the next row.
here is what I have as a code:
Private Sub CommandButton1_Click()
Dim myValue As Variant
myValue = Date
Range("A2").Value = myValue
myValue = InputBox("number")
Range("B2").Value = myValue
myValue = InputBox("name")
Range("C2").Value = myValue
myValue = InputBox("guests")
Range("D2").Value = myValue
myValue = InputBox("subject")
Range("E2").Value = myValue
myValue = InputBox("place")
Range("F2").Value = myValue
myValue = InputBox("duration ")
Range("G2").Value = myValue
End Sub
P.S im also attaching the worksheet
Thanks
Bookmarks