problem copy data from userform to sheet by multiple combobox & textbox

hello
actually i try copy data from multiple combobox to sheet but i no know how i can do that from combobx1 to 4 and textbox not copy to sheet1
the copy data occur only from combobox5 to 8 and textbox 2
this is my try

HTML Code: 

IF youstep through your code line by line using F8 in the VBA editor you will see it does put the values from the form to the sheet for all controls. However, you overwrite some of them so it looks like it doesn't do them all.
These 4 lines of your code stamp ComboBoxes 1-4 to columns A:D

Please Login or Register  to view this content.

Then the next 4 lines are overwriting them with the contents of ComboBoxes 5-8

Please Login or Register  to view this content.

BSB

hi, sintek actually this invoice i have many brands i would when i fill data the invoice it should fill one time fro many brand not every time i fill each brand alone for specific invoice this is not practical that's why i design multiple combobox

hi, BadlySpelledBuoy i know a bout your idea i just would some body help how can i overcome this problem thanks for your notice

thanks davesexel and sintek idea of davesexel works very well about the code of sintek is awesome using array thanks all