Option button
Ok,
I truelly hope this is my last question for this project! Haaa!
I have two optin buttons:
*Snap peas
*Sno peas
How do i find the selected button and place the text in my database in
(iRow, 6)?
This is what I have thus far. Thank you so much in advance!! Jennifer
' copy the data to the database
ws.Cells(iRow, 1).Value = "=R[-1]C+1"
ws.Cells(iRow, 2).Value = Me.txtInvoice.Value
ws.Cells(iRow, 3).Value = Me.txtDate.Value
ws.Cells(iRow, 4).Value = Me.cboVend.Value
ws.Cells(iRow, 5).Value = Me.cboRan.Value
ws.Cells(iRow, 7).Value = Me.txtPallet.Value
ws.Cells(iRow, 8).Value = Me.txtQty.Value
ws.Cells(iRow, 10).Value = Me.txtRepakHrs.Value
ws.Cells(iRow, 11).Value = Me.txtRepakQty.Value
ws.Cells(iRow, 12).Value = "Purchase"
--
Though daily learning, I LOVE EXCEL!
Jennifer
|