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