How to Change an Active Cell to Another Cell in Excel 2003

Save

Setting an active cell in Microsoft Excel 2003 involves the use of Visual Basic for Application programming. VBA lets you automate functions in an Excel spreadsheet. You use VBA to set the active cell, so users automatically go to a specific cell in a large spreadsheet. The activated cell lets you prompt a user, convenient when filling out forms or information in the spreadsheet.

  • Open a new or existing file in Microsoft Excel.

  • Click the "Tools" menu. Click "Visual Basic Editor" to open the VBA coding editor. Click the "Insert" menu item and select "Module." This option opens a module that "attaches" to the Excel spreadsheet. The module is the VBA code that runs in the spreadsheet.

  • Type the following code in the module editor:

    Range("A1").Select

    In this example, the "A1" cell is activated. Replace this value with your own cell you want to activate. You can also activate a range of cells. For instance, the following code activates cells from A1 to C1:

    Range("A1:C1").Select

  • Click the "Close" button to close the VBA editor. Click "Save" in the Excel toolbar to save the changes to the spreadsheet.

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!