chem101
02-21-2011, 09:42 AM
Hello Everyone,
I have a worksheet where I would like to use a UserForm with 2 listboxes. Listbox1a one would be populated by data located in a worksheet called WidgetTable. The user would select an item from listbox1a and click on an Add Item button to move that item to listbox2. There are 3 columns of data on the worksheet called WidgetTable. What I would like to have happen is when the user clicks on Ok on the userform the selected item in listbox2 goes to another worksheet in the workbook called GetWidgetData. All three columns of data are shown in listbox one but only column one is shown in listbox two after the selection is made. Upon clicking Ok on the userform I would like all three columns for the selected item in listbox2 to be copied to GetWidgetData. I can get this to work if you manually click on the item selected in listbox2 after its been selected. Naturally I don't want to have to do this manually. Also I would like to limit the selections in listbox2 to one selection. I have attached a copy of the workbook.
Any help you can provide will be greatly appreciated.
Thank you!!
I have a worksheet where I would like to use a UserForm with 2 listboxes. Listbox1a one would be populated by data located in a worksheet called WidgetTable. The user would select an item from listbox1a and click on an Add Item button to move that item to listbox2. There are 3 columns of data on the worksheet called WidgetTable. What I would like to have happen is when the user clicks on Ok on the userform the selected item in listbox2 goes to another worksheet in the workbook called GetWidgetData. All three columns of data are shown in listbox one but only column one is shown in listbox two after the selection is made. Upon clicking Ok on the userform I would like all three columns for the selected item in listbox2 to be copied to GetWidgetData. I can get this to work if you manually click on the item selected in listbox2 after its been selected. Naturally I don't want to have to do this manually. Also I would like to limit the selections in listbox2 to one selection. I have attached a copy of the workbook.
Any help you can provide will be greatly appreciated.
Thank you!!