Send Combobox values by e-mail

[Stef6]

Hi,

I have a userform with a few comboboxes (CB's) and a button. Does anyonehave a code so that when the button is pressed the values of the CB's areexported to another xls (open file, insert new line, value CB1 to column A, CB2to B, etc)?Can a userform be protected with a password so that others do not haveaccess?
Kind regards,

 

[ranman256]

combo boxes in a form are fed from a sheet already. So why read them from a sheet, to fill the box, to then write them back to a sheet?

If they are not fed this way, this means they are fed from VB code. If they are fed from code, change it and put the values in a sheet to feed the box.