Multiple comboboxes in one userform

[yiyirz]

Hi

I insert 40 combobox and user has to choose the process and create a flow. From the selection, they can generate and excel with the process flow details paste according to the flow selected. however the printed value does not follow sequence of the combobox. how do i fix this?
here are my codes.

basically i want the select case from combobox one first, then only move to combobox 2 and so on

now the result seems random.

thanks

 

[yiyirz]

So how have you determined which ranges to copy?

There must be a logic to your decision.

i select range based on this table eg if combobox selection is "coverlay Lamination" then i copy the highlighted area to the template tab

 

[Herakles]

Is it actually a table and if so what is it's name?

So what columns are we looking at?

 

[yiyirz]

Is it actually a table and if so what is it's name?

So what columns are we looking at?

Process flow table
column as below A to P

 

[Herakles]

Did you create the merged cells after the table was created?

What is the table called?

 

[yiyirz]

Did you create the merged cells after the table was created?

What is the table called?

the table is called Process Flow

yes it was merged after.

 

[My Aswer Is This]

Needing 40 comboboxes seems excessive.
A combobox is designed to select a certain value in the list of values in the combobox. One combobox can have many values to choose from.
Are you sure your familiar with this and still believe you need 40 comboboxes?

 

[yiyirz]

Hi, I already solved this issues by replacing the IF loop to For loop.

Thank you fo those who try to help.