Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
call procedure problem | Excel Discussion (Misc queries) | |||
Visual basic 6.5 question using combo box and call procedure. | Excel Discussion (Misc queries) | |||
to call procedure in a worksheet in a module | Excel Discussion (Misc queries) | |||
Run-time error '5': Invalid Procedure Call or Argument | Excel Discussion (Misc queries) | |||
Run-time error '5':Invalid Procedure call or argument | Excel Programming |