Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why?
Did you put Sub in front of it?
Sub Summonth() "Bruce Roberson" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why?
Bruce,
Did you precede it with Sub or Function? -- HTH Bob Phillips "Bruce Roberson" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why?
did you put in
Public Sub Summonth() or Sub Summonth() or Function Summonth() or Public Function Summonth() (possibly replacing Public with Private) -- Regards, Tom Ogilvy "Bruce Roberson" wrote in message ... 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 realliy have a problem with something in the previous routine? Exasperated, Bruce |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why?
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 -----Original Message----- did you put in Public Sub Summonth() or Sub Summonth() or Function Summonth() or Public Function Summonth() (possibly replacing Public with Private) -- Regards, Tom Ogilvy "Bruce Roberson" wrote in message ... 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 realliy have a problem with something in the previous routine? Exasperated, Bruce . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|