Microsoft says it's proprietary!? Won't Answer

I'm trying to develope my own routine in which when I create a sub or function End Sub Or End Function along with error handling code is automatically inserted. All has gone according to plan except I cannot get the End portion to know if I have created a Function or Sub Or What. Can You Help?
DPProAsked:
Who is Participating?
 
FoyalCommented:
Give me your e-mail address and I'll send program code for adding error traps to .frm files. You can probably figure out the rest.
0
 
sujmagsCommented:
I am not clear with ur question, pl. explain in detail
0
 
VBDesignsCommented:
So, your add-in has a "Add Function" feature that allows you to enter the function name, just like the VBx IDE, and instead of putting the header and footer, you also put in the error handling code?

Doesn't your add-in know if you're doing a sub or function?
0
 
deightonprogCommented:
At the top of the function/sub you must be inserting either sub or function.  Can't you use the same process at the bottom of the function.  Have you code for this you can post?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.