Edit Comment Macros in Excel VBA Code

Home/Excel VBA/Edit Comment Macros in Excel VBA Code

In this tutorial we will see how to Edit Comment Macros in Excel VBA Code.



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

Edit Comment Macros in Excel VBA Code: Editing or Modifying VBA Code

Macro recorder will produce lot more code than required, it store almost every action which you are performing after start recording the macro. We can open the code and delete any statement if it is not required. If you want to see the code, you can open the code window (by pressing Alt+F11) and change the code as per your requirement. If you have little command on VBA, it will be easy to change the code as per your requirement.

Edit Comment Macros in Excel VBA Code: Commenting VBA Code

Comments are the statements which are not executable. We comment the statements if you do not want to execute it or if you want provide some information in the code. It is always a good practice to provide the comments while coding, it will be easier to read and maintain the the code as program size increases. And others also can understand your code easily if you provide some comments in the code. In this topic we will see how to provide the comments.

Comment statements are prefixed with a single quote(‘). See the following example code, comments will highlight in the green in code modules.

Sub sbExampleInputBox()
'Declaring a variable to store the inputbox value
'Dim statement creates a String variable called uName
Dim uName As String
'Accepting the value from the user and (right side statement)
'assigning that value into the variable uName ('=' is an assignment operator)
uName = InputBox("Please Enter Your Name")
'Displaying the value storeed in the variable using Message Box
MsgBox uName
End Sub
By |March 17th, 2013|Excel VBA|0 Comments

About the Author:

PNRao is a passionate business analyst and having close to 10 years of experience in Data Mining, Data Analysis and Application Development. This blog is his passion to learn new skills and share his knowledge to make you expertise in Data Analysis (Excel, VBA, SQL, SAS, Statistical Methods, Market Research Methodologies and Data Analysis Techniques).

Leave A Comment

Related pages

excel macro isnumberrca report templatevb clear listboxsql ddl commands with examplesexcel 3d surface chartnested if excelwhat is a pivot chart in excelswot analysis templates powerpointexcel task templatecommandbuttonexcel 2007 lock cellsunprotect excel sheet 2013microsoft access vba programming for the absolute beginnervba string to doublecheck if workbook is open vbavba excel do while loopdaily task template excelvba excel objectnew worksheet vbaadodb connection string oraclevba cell functionproject status dashboard pptvba delete duplicate rowsv lookup tutorialfaq testing interview questions answersexcel vba dummies pdfexcel vba create folderhow to use excel lookup functionhow to crack excel macro passwordhow to delete empty rowsinsert row excel vbahow to protect column in excel 2007excel pricing templateexcel assignments for beginnersfso create foldersimple vlookup in excel 2010excel tutorial macroshow to join cells in excelweekly plan template excelexcel vba book pdfvba application inputboxapplication function vbavba excel programming pdfworking with pivot tables in excel 2007vba worksheetcells vbawhere can i find developer tab in excel 2010weekly project status report template powerpointhow to create project timeline in excelexcel templates databasenamed cells in excelhyperlinks vbaexcel formula protectionexplain macros in excelvba textboxdata control language dclmacro delete blank rowsms vba tutorialvlookup formatremoving password from excel 2007excel kpi dashboard templateexcel vba do while loopinstr vba functionmerge excel celldemographic chart templatedelete macro excelexcel vba ebookexcel vba msgbox optionshighlight duplicate values in excelgrant sql commandapplication filedialog msofiledialogfilepickeriserror excelvba copy to clipboardexcel vba activeworkbook