Cell Duplicating Userform Results

Morning All,

I have created a userform which opens automatically when I open the file.

Want I want is for a range of cells within the sheet to be populated with the entries in the userform, once these have been completed and you click ok.

The cell range is B3:Q3 and is absolute. It will always need to be these cells, and each cell corresponds to each field in the form. Therefore, if any fields in the form are left blank, the cells will need to be too.

The form fields are both text & combo boxes.

Regards

Howardjo

Thank you for your reply, however, I am having problems adapting this.

Could you please write the first one for me fully, and I will then use this as a template:

1st absolute cell range is $B$3 - this relates to a text box called 'Agent_No1' in the userform.

Regards

Howardjo

Great. Exactly what I needed. Thanks for your help and patients.

Regards

Howardjo