+ Reply to Thread
Results 1 to 3 of 3

Remark several line in the code

  1. #1
    Registered User
    Join Date
    03-20-2009
    Location
    holon
    MS-Off Ver
    Excel 2003
    Posts
    18

    Remark several line in the code

    how can i remark several line in vba code

    for example one line i remark

    Please Login or Register  to view this content.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Remark several line in the code

    You do it the same way. Start each line with an apostrophe until your done commenting.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    04-21-2009
    Location
    Melbourne,Australia
    MS-Off Ver
    Excel 2003,2007
    Posts
    34

    Re: Remark several line in the code

    I am guessing that your problem is that you have several lines that you've written and you want to make them all comment lines in one hit, avoiding the need to place an apostrophe in front of each line?
    1. Right click the VBE menu bar.
    2. Choose Edit
    3. Highlight the lines you intend as comments
    4. Click the Comment Block button on the Edit toolbar.

+ 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