+ Reply to Thread
Results 1 to 5 of 5

commenting multiple lines of code at once

  1. #1
    Registered User
    Join Date
    09-24-2009
    Location
    aus
    MS-Off Ver
    Excel 2007
    Posts
    4

    commenting multiple lines of code at once

    god i hate VBA

    Why is it so hard to do something so simple. I can't /* */ around it.
    Surely if I select it there's a hot key.

    Supposedly I should be able to find it by selecting the text and pressing edit > comment but thats missing too.

  2. #2
    Valued Forum Contributor
    Join Date
    05-14-2009
    Location
    gold coast
    MS-Off Ver
    Excel 2007
    Posts
    843

    Re: commenting multiple lines of code at once

    hello intransit.

    I cant make head nor tail of what you are trying to achive.
    could you reexplain what you need.

    cheers

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: commenting multiple lines of code at once

    If your use of VBA is as clear as your question then i am not surpirsed that you hate it.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: commenting multiple lines of code at once

    In VBA most use ' to comment alternatively you can use REM.

    You can un/comment blocks via the Edit Toolbar.
    Last edited by DonkeyOte; 09-25-2009 at 03:02 AM.

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: commenting multiple lines of code at once

    I think you have to switch the Edit Toolbar on in the VB Editor from the view menu, but as DO says that has a button to commet/uncomment blocks of code.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1