Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help:option buttons custom views and Private Sub btnPrint_Click
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help:option buttons custom views and Private Sub btnPrint_Click
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 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help:option buttons custom views and Private Sub btnPrint_Clic
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. "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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL 2007 Custom Views - Print Settings Option | Excel Discussion (Misc queries) | |||
Option Private Module | Excel Programming | |||
Option Private Module not preventing cross project referencing | Excel Programming | |||
Navigating between option buttons is not selecting the option | Excel Programming | |||
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! | Excel Programming |