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!