UserForm - Listbox selection click populates associated list in worksheet.

[jeffro]

Greetings,

I have a list named "Fruit_List" which has 4 values (Orange, Grape, Apple, Pear). I have placed these values in a list box, but am having trouble calling the related information into a new worksheet, which the user would input additional values and submit in entirety on a 3rd tracking sheet.

Any tips on where to start? Would it be a listbox into another listbox? How do I get VBA code to pull and push the info onto the respective sheets?

Example

Orange
<user listbox

O1 - These3 values populate row 1 of a sheet
O2 ______ ______ -The user enters values into cells
<user in="" values
O3 ______ ______
-A "submit" button logs all of the above into a logging worksheet in the same book, under the Orange and O1 O2 O3 headers


Can someone please point me in the right direction on how to best achieve this?

Thank You!</user></user>

 

[ww4612]

your explanation is unclear to me. did you confronted some sort of error? i don't think you need vba to do that.

 

[jeffro]

Before I start coding, I am wondering the best configuration to set this up......

Listbox into another Listbox....Listbox to 2 linked worksheets.

Basically, I hope to scale this model to 50 categories and 20 subcategories per category, so I imagine coding will make managing and logging much easier