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


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:


    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:


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

Related Searches


Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

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