R
Ryan H
I have a command button click event that I want to use to add values in a
listbox from other userform controls. The listbox will have 4 columns: Part
Description, Qty, Unit Price, Extended Price. For example,
Private Sub cmbAddItem_Click()
' code to find next available row
' add this data to next available row
Col 1: Part Description = cboPartNumber & " - " & cboPartDescription
Col 2: Qty = tbxQuantity
Col 3: Unit Price = tbxUnitPrice
Col 4: Extended Price = Val(tbxQuantity) * Val(tbxUnitPrice)
' code to sum prices in Col 4
tbxQuotePrice = ' sum of all prices in Col 4
End Sub
Is this possible? Thanks in Advance!!
listbox from other userform controls. The listbox will have 4 columns: Part
Description, Qty, Unit Price, Extended Price. For example,
Private Sub cmbAddItem_Click()
' code to find next available row
' add this data to next available row
Col 1: Part Description = cboPartNumber & " - " & cboPartDescription
Col 2: Qty = tbxQuantity
Col 3: Unit Price = tbxUnitPrice
Col 4: Extended Price = Val(tbxQuantity) * Val(tbxUnitPrice)
' code to sum prices in Col 4
tbxQuotePrice = ' sum of all prices in Col 4
End Sub
Is this possible? Thanks in Advance!!