The Real Articles
Home Submit Articles Link to Us Free Content Contact Us Online Store               Search:  
The Real Articles The Real Articles The Real Articles The Real Articles The Real Articles The Real Articles The Real Articles The Real Articles The Real Articles

Shailendra Singh's Articles in Software

  • Excel VBA-Creating Procedure
    There are two types of procedures you can create in Excel VBA: a Sub procedure and a Function procedure. What’s the difference between the two types of procedures? It’s whether or not the procedure returns a value you can use elsewhere in the program. A procedure defined as Sub can not pass its result to any other procedure in the program while a procedure defined as Function has the capability to return a value or result.
  • Excel VBA - Control the Program Flow
    While executing the program the flow generally goes top to bottom, it means from first line of the program to the last line. But some times we need interrupt the flow of the program. For this purpose we have several statements to achieve this task.
  • Excel: Interacting With User
    Accepting input from users and providing status messages are common tasks that you’ll use within many procedures. VBA lets you use two common Windows methods of displaying and asking for information from a user.
  • Working With Macros
    The most obvious benefit to creating macros in Excel is that you can automate repetitive tasks. While there’s a lot more to macros and Visual Basic for Applications than repeating a series of actions without the need for human intervention, it’s a great place to start. This section shows you how to record macros, run them using the method you find easiest, and use the built-in macro security capabilities to guard against viruses.
  • Microsoft Excel: Object-Oriented Programming
    A computer program is, at its base, nothing more than a set of instructions the computer
    executes in a specified order. In Excel, that order may change based on the contents of the
    worksheet the program is working with, but one fundamental principle behind programming languages is that if you give a program an identical data set to work with you will get the
    Same result every time.
  • A Brief History of Visual Basic for application
    Visual Basic for Application (VBA), comes from a background with a history of almost as long as that of entire computer industry. VBA is a modern dialect of the BASIC programming language that was first developed in the early 1960’s. The original BASIC language was severely limited, it was easy to learn and understand, and rapidly became very widespread. Versions of BASIC were produced for use on all types of computers.
  • Excel 2007: Advantages over Excel 2003
    The history of Microsoft Excel starts with Multiplan (A Spreadsheet Program) released in 1982. In 1995 first version of Microsoft Excel was released in 1985 for MAC. Currently version 12 has been released for Windows and coming with Office 2007. Microsoft Excel is powerful, full featured tool of Microsoft Office suite. Microsoft Excel is being used every where it may be video library or might be a multinational company. Every department need Microsoft Excel in some way to perform their day to day activities. Excel 2007 has several advantages over previous version.
  • Macro: Automate everything in Excel
    I have seen lot of people confused about macros in Microsoft Excel. They continuously ask me few questions like: what a macro is? And how it works?
    This article describes all basic information of macros like how to record, how to play and how to edit. Read this article carefully and apply it your daily routine you will see the difference in your accuracy and will save lot of time.
  • Microsoft Excel Tutorial
    This article deals with major espect of a goog Microsoft Excel Tutorial. You will learn about major applications of Microsoft Excel. It will summarize some good utitities of Excel in detail.This article will be a good thing to read first before starting a tutorial



Copyright © The Real Articles. All Rights Reserved.   
Use of our service is protected by our Privacy Policy and Terms of Service.


Powered by Article Dashboard