Why?

[Bruce Roberson]

I am in the VB Editor and have typed the name of a new
routine call Summonth()

When I key in "Summonth()" and then press enter, Visual
Basic keeps putting up the box "Compile
Error", "Expected:="

But I haven't keyed anything yet for it to object to on
that routine, so why is it making the red area the new
routine and highlighting that in Red letters? I haven't
done anything with it yet. Does it really have a problem
with something in the previous routine?

Exasperated,


Bruce

 

[Medemper]

Did you put Sub in front of it?

Sub Summonth()

 

[Bob Phillips]

Bruce,

Did you precede it with Sub or Function?

 

[Tom Ogilvy]

did you put in

Public Sub Summonth()

or

Sub Summonth()

or

Function Summonth()

or

Public Function Summonth()

(possibly replacing Public with Private)

 

[Bruce Roberson]

I just lost my mind for a minute I guess and forgot to put
the word "sub" before the name... I guess I'm so bogged
down in logic right now trying to figure out my project,
that I made a goofy mistake that I shouldn't be making at
this point.

Thanks,


Bruce