Userform Combobox - select from list, store this as default each time userform loads

[thecdnmole]

I have a combobox in a userform, populate the list using "rowsource" in the properties. What I want to do is store the selected value, which will then be the default value when the userform loads again. I am trying this, which I think works, unless someone has a better method? My other small problem is to clear the cells on the form, otherwise I get more than one cell being filled in, as I only one one of the choices to be input on sheet2.

Please Login or Register  to view this content.

then in workbook open event I have this...

Please Login or Register  to view this content.

[davesexcel]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic