reloading a userform query
 

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?

reloading a userform query
 

See solution on you other post.



--
kkkni
-----------------------------------------------------------------------
kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754
View this thread: http://www.excelforum.com/showthread.php?threadid=26729