Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
Getting value of Option button | Excel Worksheet Functions | |||
Option button | Excel Programming | |||
When using an Option Button can I... | Excel Programming | |||
value of option button | Excel Programming |