combo box within userform directing to worksheet

[wilwhiting]

I have userform that i am trying to use to input new data within a worksheet. I want a to use a combo box within this form, so that once a choice is made from from one of the optioins available in the combo box it knows what worksheet has been selected therefore allowing the data inputted in the rest of the userform to be entered into the correct worksheet.

Does anyone know of some code to start me off with this or any other options i could perhaps think of?

[davesexcel]

Here's a very quick example

Please Login or Register  to view this content.

[wilwhiting]

Many thanks!