A couple of simple questions. I'd appreciate some help.

1)How do I get a UserForm to open automatically when I open a
worksheet in Excel.

2)MORE IMPORTANTLY....

Can someone supply me with a VBA formula to locate the next empty cell
(or row or column) after entering data in one row to go to the next
for input. The code in the books I am referring to just plain doesn't
work.

3) ALSO MORE IMPORTANTLY
How do I get a command button on a
UserForm
on sheet1 to automatically open a UserForm
on sheet2 to
enter new data.