We need you!

We're working hard on the next version of Developer Fusion. Let us know what you think we should be up to!

Members

Technology Zones

Articles

Hosted By

MaximumASP

Info
Rated
Read 206,860 times
5 comments

Contents

Related Categories

VBA in Excel - Introduction

James Crowley

Introduction

With the release of Office 2000, Microsoft has now integrated Visual Basic throughout its Office software suite. This allows you to create Macros in VB, that automate or customize your office applications. The VB used to create macros retains the common VB 5 functions, and has extended keywords, objects etc for interfacing with the application, be it Excel, Word, Outlook or another application. This special version of VB is known as Visual Basic for Applications (VBA).

In this tutorial, I hope to explain how to use VBA in Excel 2000. If you have an earlier version of Excel, this tutorial will still apply, but you will find there are a few discrepancies, mainly the location and interface in which you edit the macros.

James first started writing tutorials on Visual Basic in 1999 whilst starting this website (then known as VB Web). Since then, the site has grown rapidly, and James has written numerous tutorials, articles and reviews on VB, PHP, ASP and C#. In October 2003, James formed the company Developer Fusion Ltd, which owns this website, and also offers various development services. In his spare time, he's a 3rd year undergraduate studying Computer Science in the UK. He's also a Visual Basic MVP.

Comments

Read Comments | Post Comment

  • Re: [35] VBA in Excel

    Posted by MartinMudge on 28 Aug 2007

    Hi


    What i am trying to do is use a formula to grap cells a specific distance apart, and then use autofill to copy these cells.  Currently, I am ...

  • Re: [35] VBA in Excel

    Posted by erniede on 10 Aug 2007

    This might not be the place to ask this question, but here goes...


    I'd like to put a macro in an excel worksheet that limits the time someone can use the sheet. that is, I have a "demo" of ...

  • deleting unwanted rows

    Posted by charuambekar on 08 Feb 2006


    You need to first write a code to select the entire range, then


    Selection.SpecialCells(xlCellTypeBlanks).Select
    Selection.EntireRow.Delete



    Regards,

    Charu

  • .Borders

    Posted by djlysuc on 26 Nov 2005

    I am trying to use VB in excel 2003 to check if a cell has a border. I tried the following but it does not work. Can anyone explain how I should be doing this?

    [code]
    ActiveCell.Borders(xlEdgeLeft...

  • Try something different

    Posted by richardbarnwell on 14 Nov 2005

    Why dont you try using a For loop instead. Something like:

    x = o

    For x to 100

    // What ever you want to do

    Next x

    Makes it very easy.