Compile Error: Expected Function or Variable

  • Thread starter Thread starter Nexus
  • Start date Start date
N

Nexus

how is it that I keep getting the error stated above??
The error is pointing to a sub procedure that I've
created. Would there be any method that I need to use to
call out this procedure???
 
It's hard to say for sure what the problem is without seeing the code, but
here is an example of how to call a sub, with and without arguments, from
another procedure.

Public Sub SubWithNoArgs()

MsgBox "This is SubWithNoArgs"

End Sub

Public Sub SubWithArgs(Arg1 As String, Arg2 As Long)

MsgBox "This is SubWithArgs"

End Sub

Public Sub CallOtherSubs()

SubWithNoArgs
SubWithArgs "one", 1

End Sub


--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Back
Top