Match Combo Box & Label Caption Value match to cell range then move to last row

Hi,

I have userform with combo box and textboxes.

Here I am coding for combo box selection with hidden label caption matching with cell range B5:AU5, once matched go to last row in the matched column. Reason label match is items in local language.

Friends I invite my code and give me proper coding.

Enclosed excel sheet Copy Horizantal Paste in Vertical.xlsm

Thanks

Hi mjr veverka,

Sorry for late reply.

Perfectly working.

I would like to add few options in the workbook,

1. In userform, max items to add is 7. nos So I added 7 combo boxes & text boxes with "+" command button to visible next combo & text boxes as per in each orders.
1. If I click worksheet(Data) add button, active cell order number in text box and rest as same as in worksheet(Data) New button click. disable update button in userform.
2. If I click worksheet(Data) Edit button, active cell order number, combo box, text box value in userform. disable add button in userform.
3. If I click worksheet(Data) Order Form Button, active cell order number value entries. copy paste to next worksheet(Order Form) one by one.
4. If I click worksheet(Order Form) Generate button, Sum in each items values individually & transpose to next worksheet(Quotation).

I don't know if this possible in user form. Guide & clarify me to proceed further

Here I enclosed workbook

Hi Experts,

I will go with one by one questions and my options.

The above posted 4 questions,
Question#1 - I made & resolved with individual order form to each options.
Question#2 - ItemFormA Form and get activecell order number in textbox. item entries can add. resolved.
Question#3 - Experts Here I need your support & suggestions to made it clearly.
Once Cleared I will look into Question#4, 5

Here I enclosed Excel Workbook