there are many many errors in your code, see comments
Private Sub CommandButton1_Click()
IniRow = 6 ' this value is constant, you have to check the last non empty row
IniCol = 2
Time = ComboBox3.List(ComboBox3.ListIndex)
Concentration = ComboBox2.List(ComboBox2.ListIndex)
Name = ComboBox1.List(ComboBox1.ListIndex)
Measurment = TextBox1.Value
' you have to check the optionbuttons to find the true
If Name = "Encanto Park Lake" Then
Worksheets("Encanto Park Lake").Activate
If Nutrient = OptionButton1.Value And Concentration = "20" And Time = "First" Then ' nutrient is not defined
Lines(1) = Measurment
Else
Worksheets("Rio Salado").Activate ' this is missing
If Nutrient = OptionButton1.Value And Concentration = "2" And Time = "First" Then
Lines(2) = Measurment
End If
End If
End If
Cells(IniRow, IniCol).Value = Lines(1)
Cells(IniRow, IniCol + 1).Value = Lines(2)
CloseAgrowth
End Sub
Private Sub CommandButton2_Click()
CloseAgrowth
End Sub
to do
1) select the correct Sheet
2) find the true optionbutton or use combobox for selection
3) find the last used row in column B or J or R , based on true optionbutton
4) paste entered value in the last row and correct column