Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Bart,
The only way I have found to do it is to parse the procedure declaration looking for Sub/Function, which is probably what you are doing. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "RB Smissaert" wrote in message ... 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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Bob,
Yes, that is what I do, although I thought it was a bit simpler to look at End Sub etc. Shame they didn't differentiate this in ProcType. RBS "Bob Phillips" wrote in message ... Bart, The only way I have found to do it is to parse the procedure declaration looking for Sub/Function, which is probably what you are doing. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "RB Smissaert" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|