open excel and ensure userform and worksheet are clear

[NJH88]

Hello,

I have a userform and data from the textboxes are transferred to the worksheet after the user has filled out the form. I was wondering, is there a code I can use to ensure that when the user re opens the form/excel, that all text boxes from the userforms (there are 4 userforms) as well as the text from the spreadsheet are cleared? Many Thanks

[Solus Rankin]

Please Login or Register  to view this content.

Try putting this in each userform code module

[Norie]

If you unload the userform(s) then when you open them again they should be blank, provided you haven't set any default values at design time.

[NJH88]

Thankyou guys The code you have given me Solus works so thankyou very much. Although I didnt mention, on the first 2 userforms there is a text box at the top of each with set text in which should always be there and never change. I had disabled the box so the user cannot edit it but this code deletes the text thats in it. Is there any way I could keep the code but put an exception on for these 2 textboxes?

Thankyou

[Norie]

You could use a label instead of a textbox.

[NJH88]

Thats a good idea. Although Ive just tried it and at the bottom of the userform i have a command button which concatenates all of the text from that sheet into a different textbox. When I have tried to copy the text from the label is doesnt seem to work......

[Norie]

Not work in what way?

[NJH88]

It just says 'method or data member not found'. This is the code I have put in. Seems strange not to pick up the text from the label....

Me.TextBox6.Text = Label7.Text & TextBox2.Text & ComboBox1.Text & ComboBox2.Text

[Norie]

Try Label7.Caption.

[NJH88]

Thats amazing it worked, thankyou Norie!!