Calling a procedure in a procedure
I ran your macro, as is, with the addition of the macro below. Clicking yes
ran summary. Sub summary() MsgBox "HI" End Sub -- Don Guillett SalesAid Software "Alex" wrote in message ... I'm getting the following error.. Compile Error: Expected variable or procedure, not module When I run my macro and it shows this part of my code.... Finish = MsgBox("Click YES to finish report, Click NO to end." & Chr(13) & _ "Rerun the M & S Macro if you need to add more reports", vbYesNo + vbInformation) If Finish = vbYes Then Summary '<----- THIS PART IS HIGHLIGHTED ON ERROR Exit Sub Else MsgBox "Let me know if this macro has helped you." End If BTW I do have a variable for this though it's not here. Any ideas why the error? |
Calling a procedure in a procedure
I did what you did and pulled the code seperate and I still get the error.
"Don Guillett" wrote: I ran your macro, as is, with the addition of the macro below. Clicking yes ran summary. Sub summary() MsgBox "HI" End Sub -- Don Guillett SalesAid Software "Alex" wrote in message ... I'm getting the following error.. Compile Error: Expected variable or procedure, not module When I run my macro and it shows this part of my code.... Finish = MsgBox("Click YES to finish report, Click NO to end." & Chr(13) & _ "Rerun the M & S Macro if you need to add more reports", vbYesNo + vbInformation) If Finish = vbYes Then Summary '<----- THIS PART IS HIGHLIGHTED ON ERROR Exit Sub Else MsgBox "Let me know if this macro has helped you." End If BTW I do have a variable for this though it's not here. Any ideas why the error? |
All times are GMT +1. The time now is 12:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com