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

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

Boris

Which line is highlighted when you get that error? If it's the Show line,
then make sure you spelled the userform name correctly. Also the second
line of your sub doesn't have a comment indicator although that may be due
to line wrap in your message. Otherwise it look OK to me.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"boris" wrote in message
...
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

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

Dick, oddly enough, it was the blank line after the
statement, before the End Sub that needed taking out. I
don't know if that's common, but I am almost certain that
Excel doesn't care about that. As far as the name, I
knew I had spelled it right because I do no caps
intentionally to have Excel capitalize as I am writing.
Anyway, works now. Thanks for the help.

Boris
-----Original Message-----
Boris

Which line is highlighted when you get that error? If
it's the Show line,
then make sure you spelled the userform name correctly.
Also the second
line of your sub doesn't have a comment indicator
although that may be due
to line wrap in your message. Otherwise it look OK to
me.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"boris" wrote in message
...
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

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



.