Editing the VBE with Code (Excel 2000 SR-1)

Topic

New Reply

Hello,

I was going to try to write a procedure to insert comments into the code module where the cursor is, but I cannot figure out how to determine what line number is the “Active” line or even which procedure is the “Active Procedure”. Can any one help? If there is already a tool to do this, I would be happy to use it instead of writing my own procedure.

Thanks,

Reply | Quote

Replies

Chip Pearson has some code that works with modules and could probably be adapted. Though nothing specific. It should give you hints as to the objects and possible properties to use.

I don’t think you will be able to know where the cursor is the VB, you will not be able to code like that “interactively”

Steve

Reply | Quote

Chip Pearson has some code that works with modules and could probably be adapted. Though nothing specific. It should give you hints as to the objects and possible properties to use.

I don’t think you will be able to know where the cursor is the VB, you will not be able to code like that “interactively”

Steve

Reply | Quote

A terribly useful utility:

http://www.mztools.com[/url%5D

Reply | Quote

A terribly useful utility:

http://www.mztools.com[/url%5D

Reply | Quote