How to install and configure VBA - Excel Macros || VBA Developer

VBA - Excel Macros

VBA (Visual Basic for Applications) is the programming language of Excel and other Office programs. 1 Create a Macro: With Excel VBA you can automate tasks in Excel by writing so called macros. ... A loop in Excel VBA enables you to loop through a range of cells with just a few codes lines
Step 1 − First, enable 'Developer' menu in Excel 20XX. To do the same, click File → Options.
Step 2 − Click ‘Customize the Ribbon’ tab and check 'Developer'. Click 'OK'.
Developer in VBScript
Step 3 − The 'Developer' ribbon appears in the menu bar.
Developer in VBScript
Step 4 − Click the 'Visual Basic' button to open the VBA Editor.
Developer in VBScript
Step 5 − Start scripting by adding a button. Click Insert → Select the button.
Developer in VBScript
Step 6 − Perform a right-click and choose 'properties'.
Developer in VBScript
Step 7 − Edit the name and caption as shown in the following screenshot.
Developer in VBScript
Step 8 − Now double-click the button and the sub-procedure outline will be displayed as shown in the following screenshot.
Developer in VBScript
Step 9 − Start coding by simply adding a message.
Private Sub say_helloworld_Click()
   MsgBox "Hi"
End Sub
Step 10 − Click the button to execute the sub-procedure. The output of the sub-procedure is shown in the following screenshot.
Developer in VBScript
Thankyou

Comments

  1. Bruce David23 April 2020 at 01:46

    Hello everyone..Welcome to my free masterclass strategy where i teach experience and inexperience traders the secret behind a successful trade.And how to be profitable in trading I will also teach you how to make a profit of $12,000 USD weekly and how to get back all your lost funds feel free to email me on( brucedavid004@gmail.com ) or whataspp number is +22999290178  

    ReplyDelete

Post a Comment

Popular posts from this blog

How to Hack Whats app messages using Spyzie (With out knowing)

Image
Requirements you need : 1) Spyzie . Part 1: Hack Someone's WhatsApp Messages without them Knowing Using Spyzie A great way of how to hack someone WhatsApp without them knowing is by using the highly-advanced software  Spyzie .It works with both android and iOS devices. When it is used to hack whatsapp messages on an android phone, it uses features like capturing screenshot and keylogging to let you track every activity on the target device. Though you need to install the monitoing app on the target phone, the process is pretty simple. And when it is installed, it will work in stealth mode without leaving any trace. On the other hand, if you would like to monitor an iPhone, you don't even need to touch the target device. Here is a live demo:  https://my.spyzie.com/livedemo/dashboard.html With this program, you are guaranteed complete access to the other phone's WhatsApp conversation as they come and go without the slightest knowledge of the other party. If you w...
Read more

5 Tips To Get Rid of A Headache Quickly without Medicine

Image
Headaches are a common condition that many people deal with on a daily basis. To get rid of Headache, Here are the 5 tips that helps you in  Natural  way. 1. Drink Water Inadequate hydration may lead you to develop a headache. In fact, studies have demonstrated that chronic dehydration is a common cause of tension headaches and migraines. Thankfully, drinking water has been shown to relieve headache symptoms in most dehydrated individuals within 30 minutes to three hours. What’s more, being dehydrated can impair concentration and cause irritability, making your symptoms seem even worse. To help avoid dehydration headaches, focus on  drinking enough water  throughout the day and eating  water-rich foods . 2. Take Some Magnesium Magnesium  is an important mineral necessary for countless functions in the body, including blood sugar control and nerve transmission. Interestingly, magnesium has also been shown to be a safe...
Read more

What is Asp.Net MVC || Latest version of MVC

MVC MVC stands for  Model-View-Controller  is an architectural pattern that seperates in to three logical components.  ASP.NET MVC framework is a lightweight, highly testable presentation framework that is integrated with the existing ASP.NET features 1)Model - Data related logic(Works b/w View and Controller) like db operations 2)View - UI logic(Final User Interact) 3)Controller - Business logic(Interface between Model and View) Versions in Asp.net MVC MVC Version Visual Studio .Net Version Release date Features MVC 1.0 VS2008 .Net 3.5 13-Mar-2009 MVC architecture with webform engine Routing HTML Helpers Ajax Helpers Auto binding MVC 2.0 VS 2008, .Net 3.5/4.0 10-Mar-2010 Area Asynchronous controller Html helper methods with lambda expression DataAnnotations attributes Client side validation Custom template Scaffolding MVC 3.0 VS 2010 .Net 4.0 13-Jan-2011 Unobtrusive javascript validation Razor view engine Global filters Remote vali...
Read more