reloading a userform query

  • Thread starter Thread starter anthony slater
  • Start date Start date
A

anthony slater

I've made a simple user form consisting of 3 input text
boxes. After inputting values, a command button is clicked
and the user form closes and populates 3 cells in a
worksheet with the values.

I have another command button (from the forms menu) on the
worksheet that will clear the inputted data and re-load
the user form ready for another input.

At the moment the user form reloads but the previous
values are still there. The following code is used: -

Private Sub commandbutton32()
Sub button32_Click()
Range("a1").ClearContents
Range("a2").ClearContents
Range("f3").ClearContents
Range("f5").ClearContents
Range("f9").ClearContents
UserForm1.Show

End Sub

How can I get the user userform to reload with blank text
boxes?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing user forms 4
reloading a userform problem 1
entering data into multiple sheets 9
Executing Userform 2
Copy Array to Array, how to and should I? 13
Values don't behave when converting text to values in userform 2
Hidden sheet bleeds through 3
Clear corresponding cells in other worksheet 4

Back
Top