loading userform form open

hi everyone

i have created an userform which i would like to show when the file is opened, which i can do on open

but how do clear out each textbox when i next use the form, for example the form is completed and then a 'continue' button is pressed and the information is transferred to the spreadsheet and the form is closed - tried using
userform1.hide and unload userform1 but neither appear to work

any ideas?

thanks

yes i did....no luck

any other suggestions??