View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ryan H Ryan H is offline
external usenet poster
 
Posts: 489
Default Fill Listbox Columns With Other Userform Control Values

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!!
--
Cheers,
Ryan