Help:option buttons custom views and Private Sub btnPrint_Click

J

JCIrish

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
 
B

Bob Phillips

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)
 
J

JCIrish

Thanks, Bob. I checked that a zillion times and was baffled because they were
both the same. I just went back and cleared everything out of the caption and
reentered and it now works. Must have been an extraneous character that I
couldn't spot somewhere in there. Thanks for causing me to go back and do
what I did.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top