InputBox to input data for each row

You could use something like this:

Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Me.Cells(3, "C"), Target) Is Nothing Then
        If Me.Cells(3, "C").Value = 1234 Then
            Me.Cells(4, "C").Value = Application.InputBox("Enter a date")
            Me.Cells(5, "C").Value = Application.InputBox("Enter a name")
            Me.Cells(1, "C").Value = Application.InputBox("Enter an order ID")
        End If
    ElseIf Not Intersect(Me.Cells(4, "C"), Target) Is Nothing Then
        If Me.Cells(4, "C").Value = 9854 Then
            Me.Cells(4, "C").Value = Application.InputBox("Enter a date")
            Me.Cells(5, "C").Value = Application.InputBox("Enter a name")
            Me.Cells(1, "C").Value = Application.InputBox("Enter an order ID")
        End If
    End If

End Sub

However, I have to question overwriting the data in C4 with the code when you have to put 9854 into C4 to trigger the code. Did you mean to do that?

Originally Posted by davegugg

You could use something like this:

Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Me.Cells(3, "C"), Target) Is Nothing Then
        If Me.Cells(3, "C").Value = 1234 Then
            Me.Cells(4, "C").Value = Application.InputBox("Enter a date")
            Me.Cells(5, "C").Value = Application.InputBox("Enter a name")
            Me.Cells(1, "C").Value = Application.InputBox("Enter an order ID")
        End If
    ElseIf Not Intersect(Me.Cells(4, "C"), Target) Is Nothing Then
        If Me.Cells(4, "C").Value = 9854 Then
            Me.Cells(4, "C").Value = Application.InputBox("Enter a date")
            Me.Cells(5, "C").Value = Application.InputBox("Enter a name")
            Me.Cells(1, "C").Value = Application.InputBox("Enter an order ID")
        End If
    End If

End Sub

However, I have to question overwriting the data in C4 with the code when you have to put 9854 into C4 to trigger the code. Did you mean to do that?

I did not mean to do this, "guess I was in a rush to get out to lunch".

It would of been C3, D3, E3... and so on. Also I would like to have the inset data that can be anything activate the input boxes so 1234 can be "anything entered in cell"
Example:
C3 insert data "1234"
Pop up asking to enter a date - Fills the data from input box to cell C4
Pop up asking to enter name - Fills the data from input box to cell C5
Pop up asking to enter Order ID - Fills in data from input box in C1

D3 insert data "9854"
Pop up asking to enter a date - Fills the data from input box to cell D4
Pop up asking to enter name - Fills the data from input box to cell D5
Pop up asking to enter Order ID - Fills in data from input box in D1

Sorry for the improper information at first..

Seems a pointless exercise - it would be quicker to just enter the data into the cells