austenr
04-24-2006, 09:39 AM
Does anyone know why if you select vbYes in the code below it will not display userform2? This works fine in one module but the same code does not show the userform in the other module. If you select vbYes in the one that does not work, the value in ans = "38"
Sub AskToPrintReport()
Dim ans As String
ans = MsgBox("Do you want to create a report?", vbYesNo) + vbQuestion
If ans = vbYes Then
UserForm2.Show
End If
End Sub
Sub AskToPrintReport()
Dim ans As String
ans = MsgBox("Do you want to create a report?", vbYesNo) + vbQuestion
If ans = vbYes Then
UserForm2.Show
End If
End Sub