what code do i add to a commandbutton2 for the next?

they enter name and lastname in the textbox. when hitting commandbutton2 i
need that data from textbox1 in the next open cell sheet1 column c down. and
then command button disable. refresh either userform1 or listbox1

should i use unload userform1 or rather userform1.hide?


thanx nigel



"Nigel" wrote:

Load puts the UserForm into memory but does not show the form in the
interface, UserForm.show loads and then shows it.



--

Regards,
Nigel




"pswanie" wrote in message
...
jip i meant show.

btw whats the diff?

"Nigel" wrote:

If IsEmpty(Sheets("Sheet1").Range("C42")) Then UserForm1.Show

I presume you mean Show the UserForm, but if you meant Load then use

If IsEmpty(Sheets("Sheet1").Range("C42")) Then Load UserForm1


--

Regards,
Nigel




"pswanie" wrote in message
...
what code whould i need to add to tell the userform only to load if
Sheet1
cell c42 is empty.