Results 1 to 7 of 7

Simple: Commenting Multiple lines in VBA editor

This is a discussion on Simple: Commenting Multiple lines in VBA editor within the Excel Questions forums, part of the Question Forums category; I remember, it's possible to highlight several lines in VBA editor and then click on some button to comment them ...

  1. #1
    Board Regular
    Join Date
    Mar 2009
    Posts
    94

    Default Simple: Commenting Multiple lines in VBA editor

    I remember, it's possible to highlight several lines in VBA editor and then click on some button to comment them all.
    Could you please remind me which button(s)?

    Thanks a lot!

  2. #2
    Board Regular
    Join Date
    Jul 2006
    Location
    Brussels
    Posts
    7,068

    Default Re: Simple: Commenting Multiple lines in VBA editor

    It's on the Edit toolbar. One icon to comment, one to uncomment.
    Regards,


    Wigi


    Excel MVP 2011, 2012, 2013



    For more Excel memes: visit http://www.wimgielis.be ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  3. #3
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690

    Default Re: Simple: Commenting Multiple lines in VBA editor

    Quote Originally Posted by wigi View Post
    It's on the Edit toolbar. One icon to comment, one to uncomment.
    Yes and it's called "Comment Block" AND, it may not be present on your toolbar. If not, right click a toolbar in the VBE and choose "Customize". On the Commands tab, choose "Edit" and scroll down the Commands list until you find it. Drag to a toolbar. Do the same for the "Uncomment Block" icon

    lenze
    If you have to tell your boss you're good with Excel, you're NOT!!
    All I know about Excel I owe to my ignorance!
    Scotch: Because you don't solve great Excel problems over white wine

  4. #4
    Board Regular
    Join Date
    Mar 2009
    Posts
    94

    Default Re: Simple: Commenting Multiple lines in VBA editor

    Thanks a lot! Very helpful!

  5. #5
    New Member
    Join Date
    Jan 2012
    Posts
    1

    Default Re: Simple: Commenting Multiple lines in VBA editor

    Quote Originally Posted by lenze View Post
    Yes and it's called "Comment Block" AND, it may not be present on your toolbar. If not, right click a toolbar in the VBE and choose "Customize". On the Commands tab, choose "Edit" and scroll down the Commands list until you find it. Drag to a toolbar. Do the same for the "Uncomment Block" icon

    lenze

    Thanks!! Added to by toolbar now.

  6. #6
    New Member
    Join Date
    Jul 2012
    Posts
    8

    Default Re: Simple: Commenting Multiple lines in VBA editor

    Quote Originally Posted by wigi View Post
    It's on the Edit toolbar. One icon to comment, one to uncomment.
    What about in excel 2010 built-in VBA editor?

  7. #7
    VoG
    VoG is offline
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    61,507

    Default Re: Simple: Commenting Multiple lines in VBA editor

    It is exactly the same.
    HTH, Peter
    Please test any code on a copy of your workbook.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com