Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
userform freezes
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
userform freezes
Hi flow23, Are you opening the form through a command button on a spreadsheet? If so put this in your code for the commandbutton. Code: -------------------- Private Sub Commandbutton1_Click() Userform1.Show End Sub /CODE] Change userform number to number you are currently using. To open a sheet that is hidden, from a commandbutton in the userform place code like this in the appropriate command button. Code: -------------------- Private Sub CommandButton1_Click() If Worksheets("sheet1").Visible = True Then Worksheets("sheet1").Visible = False Else Worksheets("sheet1").Visible = True End If End Sub -------------------- To print the sheet put code like this in your userform for Commandbutton2. Change Sheet # to sheet you are currently using. Code: -------------------- Private Sub Commandbutton2_Click() Application.ScreenUpdating = False Sheets("Sheet1").Visible = True Sheets("Sheet1").Select Range("A1:C10").Select ActiveSheet.PageSetup.PrintArea = "$A$1:$C$10" ActiveWindow.SelectedSheets.PrintOut copies:=1, collate:=True Sheets("Sheet1").Visible = False Application.ScreenUpdating = True End Sub -------------------- To close the userform with a command button use code like this for commandbutton3. Code: -------------------- Private Sub Commandbutton3_Click() Unload UserForm1 End Sub -------------------- hope this helps, Larry -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=487959 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Worksheet to Userform | Excel Discussion (Misc queries) | |||
UserForm Data to Spreadsheet | Excel Discussion (Misc queries) | |||
Data Validation Cell - Move to UserForm | Excel Worksheet Functions | |||
Cell Content from UserForm Not Retained | Excel Discussion (Misc queries) | |||
How can I run a macro in the background whilst a UserForm is visib | Excel Discussion (Misc queries) |