Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
fill userform textbox from userform listbox clik event | Excel Programming | |||
Userform - with Commandbutton fill a Listbox with data.. | Excel Programming | |||
Fill a Listbox with mult. Variables in userform | Excel Programming | |||
Fill values into a listbox matching selected values from a combobox | Excel Programming | |||
Fill a Listbox with Values from a Pivot Table Field - an Example | Excel Programming |