Fill Listbox Columns With Other Userform Control Values

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!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top