Here is what I am trying to accomplish.
I have a listbox (lbProducts) with a list of products and a set of 10 textboxes (txtProduct1 to txtProduct10) There is a CommandButton (btnSelect) in between listbox and textboxes.
So, when the user clicks on an object in listbox and clicks on "btnSelect", the select object is copied to next available textbox, starting from txtProduct1.
In short I want to allow user to select upto 10 objects from listbox and copy them to txtProduct 1 to txtProduct 10 which eventually will go into inputdata sheet.
Please find the attached workbook for reference.
Please Advise.
Bookmarks