first time creating a user form.
BAsically 3 buttons to execute macros.
Private Sub CommandButton1_Click()
data
form.hide
End Sub
Private Sub CommandButton2_Click()
Print1
form.hide
End Sub
Private Sub CommandButton3_Click()
ActiveWorkbook.Close
form.hide
End Sub
Private Sub CommandButton4_Click()
Print2
fom.hide
End Sub
however when I click the first buttion.. it doesnt execute the macro.
2nd and 3rd button are ok.
but it freezes
and exit is perfect
Hi flow23,
Are you opening the form through a command button on a spreadsheet? If so put this in your code for the commandbutton.
Change userform number to number you are currently using.
Please Login or Register to view this content.
To open a sheet that is hidden, from a commandbutton in the userform place code like this in the appropriate command button.
Please Login or Register to view this content.
To print the sheet put code like this in your userform for Commandbutton2. Change Sheet # to sheet you are currently using.
To close the userform with a command button use code like this for commandbutton3.Please Login or Register to view this content.
Please Login or Register to view this content.
hope this helps,
Larry
Last edited by keithl816; 11-24-2005 at 01:34 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks