userform with 3 comboboxes and textboxes send to sheet

[cfinch100]

hi
the userform has 3 comboboxes and 12 textboxes i have copied the first combo1 to sheet3 'a' cell the textboxes will be added to cells b,c,d on the same row
my question is combo2 and its textboxes need to be added to the next row
then combo3 to the next row,the first one copies data over but not the others have played about with it and only one row copies,
cheers colin

[Abhi1687]

try using DO UNTIL LOOP thats the way around i can think of at the moment

[cfinch100]

hi
update have used commandbuttons to copy to sheet and linked them together ,does any one know better way
cheers colin

[jaslake]

Hi Colin

As a suggestion, you don't need a Command Button to update each UserForm row...it can be done with one Button (with no Links).