| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine procedure name at cursor?
Thanks Myrna, I'll give this a go!
Myrna Larson wrote: There are a couple of methods that you need for this: GetSelection, and ProcOfLine, both of which are in the VBIDE library. The following is extracte from Help for the two methods. You can get the line number from the StartLine argument of the GetSelection method, and if you supply that to GetProcOfLine, it will return the procedure name. The following worked for me from the immediate window: application.vbe.activecodepane.getselection L1&,C1&,L2&,C2& debug.print application.VBE.activecodepane _ .codemodule.ProcOfLine(L1&,vbext_pk_Proc) GetSelection Method Returns the selection in a code pane. Syntax object.GetSelection(startline, startcol, endline, endcol) ProcOfLine Property Returns the name of the procedure that the specified line is in. Syntax object.ProcOfLine(line, prockind) As String On Tue, 15 Mar 2005 15:47:49 -0000, "Amit Shanker" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to determine cursor location? | Excel Discussion (Misc queries) | |||
| Function to determine current cursor position? | Excel Worksheet Functions | |||
| move cursor on one sheet moves cursor on all sheets | Excel Discussion (Misc queries) | |||
| Can I change the "white cross" cursor in Excel to another cursor? | Excel Discussion (Misc queries) | |||
![Amit Shanker[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
