Userform Listbox selection & Value update based on column

I am creating an userform where user can select existing materials, and input stock quantity.

Process:

1. Userform open
2. User will select which stock column to input values (Stock1 ~ Stock10).
3. User will select a material on the listbox.
4. User can input stock quantity & select where the stock is from.
5. When updating, the stock quantity will be added on the selected Stock column.

I got to the part on populating the listbox; and label showing selected material in the listbox to show name & color.

Stuck at: I am stuck on how to make:

• selected stock column to 开发者_JAVA技巧be input column. *this is the part which user will use combobox to select available stock column on the left chart.
• selected listbox material to be input row.

Example: Below are the images of the example form & userform.

• Left image is where the stock data will be input (Stock1 ~ Stock3).
• Right image is the userform; user will follow the process above; and it will be entered into the left chart.

Thank you all in an advance.