Thanks cush. My code is certainly in the right place, associated with
the correct button on the userform ... Here is the code associated with
the button
Code:
--------------------
Private Sub CommandButton1_Click()
' store data on variables worksheet
Worksheets("variables").Range("curinitials").Value = initials.Value
Worksheets("variables").Range("curbarcpref").Value = barcpref.Value
Worksheets("variables").Range("curbarcfin").Value = barcfin.Value
' hide first step userform
Box_details.Hide
'show secondstep userform
box_contents.Show
End Sub
--------------------
Box_details is the first userform (on which CommandButton1 is located),
box_contents is the userform for the next step. The code dies at the
"box_contents.Show" point.
--
CFD
------------------------------------------------------------------------
CFD's Profile:
http://www.excelforum.com/member.php...o&userid=27306
View this thread:
http://www.excelforum.com/showthread...hreadid=473653