Sleeper: Initialize a UserForm

[spannerj]

Hi there,

I have been struggling away with creating a userform.
I have a workbook with a command button which launches a user form. At present I have coded userform.show in the onclick event.

I want to be able to initialize all my combo boxes and list boxes to a value from the workbook and then save any changes back to the workbook when finished. I know should be using the userform.initialize event but I can't seem to get it to work.

Could someone give me some pointers please.

I have attached my sheet so far if someone would be so good as to look at it for me.

[Norie]

What do you actually want to populate the form with when it's opened?

[spannerj]

I want to have a cell to store a default display value for each combo box on my form and my option buttons so that values are already displayed when the form is launched for the first time.

I then want to save all values that the user picks into the cells where the default values were stored so that on opening the next time the users last choices are in the relevant boxes.

I hope thats clear.

Cheers for any help.