I have several controls (i.e. textbox, combobox and checkbox) inside a frame
in a form and need ALL their values to update to their corresponding cells in
a worksheet when click a command button.

Is there a quicker way to do so rather than writing a line for each control
to force the blanket update?

Thanks in advance :-)

Sam