Hi all,

I need help

I have made a form where u input data that on closing is transfered to a
worksheet

eg: Range("d3").Value = Membernumber.Value

on this form I have placed a button that unhides another form for optional
info.
I want to transfer this info to some hidden text boxes so that on closing
the main form all data is transfered to the worksheet.

I have used this code on closing the second form but it doesn't work.

UserForm1!advisername.Value = advisername.Value
UserForm1!apptdate.Value = Appt_date.Value
UserForm2.Hide

THanks in advance
Mark