Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform Can't seem to work right
Hello,
have userform with two Option buttons and two command buttons one for OK and Cancel. Here's the code for the OK button: Private Sub CommandButton1_Click() ' Dim MyButtons As Object If OptionButton1.Value = True Then Sheets("ZSDQT002LATEST").PrintPreview UserForm1.Hide ElseIf OptionButton2.Value = True Then Application.GetSaveAsFilename End If End Sub When I select the Print Preview option and click OK it goes to Print Preview, but the Userform doesn't close and can't close it and excel gets stuck. So I have to End program. Does anyone have idea why this is happening. Thanks, Juan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make userform work publically with hidden sheets? | Excel Discussion (Misc queries) | |||
How to make userform work publically with hidden sheets? | Excel Worksheet Functions | |||
How to have a userform displayed and be able to work in a different spreadsheet | Excel Programming | |||
Label Caption Just Wont Work on UserForm | Excel Programming | |||
Userforms and autofilters - Autofilters don't seen to work with userform | Excel Programming |