Dear Neon,
tried your suggestion:
<code>
Sub fContinueEntry()
'Get Machine value
RowNum = ActiveCell.Row
<highlight>
Sheet.Range(RowNum, 3).Value = Sheet.Cells(B, 1)</highlight>
Dim MachineIndex As Integer
MachineIndex = ActiveCell(RowNum - 4, "B").Value
Dim Machine As String
Machine = DropDown5.TargetValue
ActiveCell(RowNum, 2).Value = Machine
Sheet.Range(RowNum, 2).Value = Sheet.Cells(B, 1).Value
Dim Tube As Double
Tube = InputBox("Enter Tube")
ActiveCell(NewRowNum - 10, 2).Value = Tube
Dim CLR As Double
CLR = InputBox("Enter C.L.R.")
ActiveCell(NewRowNum - 10, 3).Value = CLR
Dim Grip As Double
Grip = InputBox("Enter Grip Length")
ActiveCell(NewRowNum - 10, 4).Value = Grip
End Sub
/<code>
And while it compiles ok, I get a Runtime Error 424 Object Required when try to run it. Am I doing something wrong?</code></code>