oxicottin
01-24-2013, 05:26 PM
There are 4 columns in my UserForm’s listbox, and If I select a row I needed the value in the selected row for each column to be copied to a worksheet (WorkOrder).
Listbox column 1’s value would be moved to Range("C10:C46")in WorkSheet (WorkOrder)
Listbox column 2’s value would be moved to Range("E3")in WorkSheet (WorkOrder)
Listbox column 3’s value would be moved to Range("C6")in WorkSheet (WorkOrder)
Listbox column 4’s value would be moved to Range(F6")in WorkSheet (WorkOrder)
Is the columns just identified by a column number or how are they identified? And is there a way to just let the user select one row. The listbox is a multi select listbox but for this I need to just allow the user to select only one row. How can I do this? I included a portion of my workbook that shows data ect.
Thanks!
Listbox column 1’s value would be moved to Range("C10:C46")in WorkSheet (WorkOrder)
Listbox column 2’s value would be moved to Range("E3")in WorkSheet (WorkOrder)
Listbox column 3’s value would be moved to Range("C6")in WorkSheet (WorkOrder)
Listbox column 4’s value would be moved to Range(F6")in WorkSheet (WorkOrder)
Is the columns just identified by a column number or how are they identified? And is there a way to just let the user select one row. The listbox is a multi select listbox but for this I need to just allow the user to select only one row. How can I do this? I included a portion of my workbook that shows data ect.
Thanks!