ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   procedure won't call (https://www.excelbanter.com/excel-programming/273601-re-procedure-wont-call.html)

John Gittins

procedure won't call
 
If there is a form called PrintSelection and a routine called the same this
can lead to some problems. It is hard to tell looking at an email vesion but
make sure that the "PrintSelection" mentioned in the description at the
begining is actually treated as text (usually shows as green) and not being
treated as an instruction.

"boris" wrote in message
...
I am a novice, so apologies in advance...

Have a button on a sheet which I want to have call a
procedure that simply shows a userform. I am assigning
the macro to the button and the procedure is simply

Sub GetPrintPrefs()
' Shows the PrintSelection userform, then runs
PrintSelection
' procedure to do actual print

PrintSelection.Show

End Sub

, with PrintSelection being the name of the userform. I
thought it was that simple, but it gives me a "Compile
Error: Expected Function or variable".

Help?

Boris





All times are GMT +1. The time now is 03:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com