Help:option buttons custom views and Private Sub btnPrint_Clic
The button caption and the view name are the same,"Credit Card Summary YTD"
"Bob Phillips" wrote:
Must be a problem with the button caption, and the view name. What is it?
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"JCIrish" wrote in message
...
In the following code grpRows refers to a custom form with a frame
containing
three option buttons. Each option button corresponds to a custom view. The
code works when either of the first two option buttons is chosen on the
Print
command button of the form. If the third option button is chosen the code
fails and I get the message ""Run Time error 5. Invalid procedure call or
argument." The first two custom views are on sheet 1 of the workbook
while
the third custom view is on sheet 4 . What am I doing wrong here and how
do
I correct this? Any help greatly appreciated.
Private Sub btnPrint_Click()
Dim myControl As Control
Dim myView
For Each myControl In grpRows.Controls
If myControl.Value = True Then
myView = myControl.Caption
Debug.Print myView
End If
Next myControl
ShowView myView
Unload Me
MsgBox "Printing"
End Sub
Sub ShowView(ViewName)
'
ActiveWorkbook.CustomViews(ViewName).Show
End Sub
|