yes, I have these senior moments when things end up backwards. Glad you
worked it out.

"tress" wrote:

Sorry, I have sorted it, the Unload Me had to come before the Show Form.

Thanks

"tress" wrote:

Hi JLGWhiz,

Thats brilliant thanks, thought it would be something like that, must be
that Friday feeling.

Thanks Phil

"JLGWhiz" wrote:

For Q.2.

Private Sub CommandButton1_Click()
UserForm 2.Show
Unload Me
End Sub

Private Sub CommandButton1_Click()
UserForm 1.Show
Unload Me
End Sub

The first one goes behind the command button on userform 1. The second one
goes behind the command button on userform 2.

"tress" wrote:

Hi,

I have done most of the complicated parts of this task but seem to be
getting stuck on what I thought would be the simple part.

I am using Excel 2003 in a Windows NT Enviroment

Question 1

I have an Excel Document, that when you open it, it Shows the Form that I
have built but with the Excel sheet behind it, what I want is just to see
the form, I think the problem lies with when you click the ok button it
writes data from the form to the excel sheet I still want this to happen, I
just dont want the user to see this.

Question 2

I have 2 forms, what I want to do is have a button on the first form that
takes you to the second but closes the first, then a button on the second
that takes you back to the first and shuts the second.

Can anyone help with this or point me in the right direction?

Thanks