{"id":12142,"date":"2012-06-10T10:05:04","date_gmt":"2012-06-10T10:05:04","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=1821"},"modified":"2022-08-12T11:17:46","modified_gmt":"2022-08-12T11:17:46","slug":"excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/06\/excel-macro-tutorial-basics-fo-vba-basic-syntaxes-required-while-coding\/","title":{"rendered":"Excel Macro Tutorial : Basics of VBA (Basic Syntaxes required while coding)"},"content":{"rendered":"
Let’s take a brief recap of all things you have studied so far in Excel Macro Tutorial.<\/p>\n
So far you have learnt so many basic stuffs about Excel Macros under Excel Macro Tutorials<\/a>. You have learned about all the Controls available in Excel Macros and also how to use them. You have also learned How to Record and Run a Macro in Excel. You also have learnt some basic Programming Lessons as well like If Else Statements<\/a>, For Loop<\/a>, While and DO While Loops<\/a> etc.<\/p>\n So far we have studied all the basic stuff about Excel Macro, which will be required for you to start developing a tool in Excel Macro. This is the most frequently used stuff in excel macro. Reading and writing the data in excel cells. Here are the simple syntax to do so.<\/p>\n Cells(<\/strong><Row Index> , <Column Index><\/i>).Value = <\/strong><Your Value><\/i>
\nHere I have collected a Set of questions or doubts, which are asked as soon as you start coding your own.<\/p>\n
\n1. How to read or Write some value in an Excel Cell?
\n2. How to read or write something in an Excel Cell of a Specified Sheet of the same Workbook.
\n3. How to Select a Worksheet from the Same Workbook?
\n4. How to Activate a Worksheet from the same Workbook?
\n<\/font>\n<\/div>\n1. How to put some value in an Excel Cell ?<\/h3>\n
\nOR<\/strong>
\nRange(<\/strong><Column Name><Row Index><\/i>).Value = <\/strong><Your Value><\/i>
\n <\/p>\nSteps to Do:<\/h2>\n