Thread: VBE question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default VBE question

I know you can do:

strProcName = .ProcOfLine(lCodeLine, lProcType)

and the variable lProcType will tell you then if the procedure is a
Sub/Function or
a Property Get or Property Let or Property Set, with the values 0 to 3.
It won't differentiate though between a Sub or a Function.
I can do this, but it gets a bit messy.
What is the simplest way to do this?

RBS