Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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,

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

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

    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

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    A terribly useful utility:

    http://www.mztools.com
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •