View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Amit Shanker[_2_] Amit Shanker[_2_] is offline
external usenet poster
 
Posts: 11
Default Determine procedure name at cursor?

Hi,

Is there a way to programmatically determine the name of the
procedure/function where the cursor is currently located? To explain,
suppose a regular VBA module has 3 procedures in it (Foo1, Foo2 & Foo3); my
query is if I click anywhere within Foo2 in the code module window, is there
any way to determine that I have my cursor currently within Foo2?

The reason I need to determine this is to click within any procedure, and
then call this procedure from another one using the Application.Run method.

Thanks,
Amit