How to Set the Cell Value in VBA

Written by l.p. klages
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Set the Cell Value in VBA
One of the core features of VBA in Excel is to assign values to cells after calculations. (number background image by kuhar from Fotolia.com)

Visual Basic for Applications, or VBA for short, is the scripting language used in Microsoft Office to automate tasks in applications such as Microsoft Excel. Since Excel is ultimately used for displaying related data in spreadsheet cells, one of the core features of VBA in Excel is to assign values to those cells after calculations. Not only can you assign values to single cells, but also to ranges, using VBA.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Copy and paste the following code into your VBA module:

    Sub SetValue()

    Worksheets("Sheet1").Activate
    
    ActiveCell.Value = 35
    

    End Sub

  2. 2

    Replace the "Sheet1" text with the cell to which you want to assign a value. For example, if you want to assign a value to the cell in column B, row 24, then you'd change the code from "Sheet1" to "B24."

  3. 3

    Replace the 35 with the value you want to assign to your cell. For example you could make it a number, such as 25, or a string of text, such as "Hello."

  4. 4

    Call the SetValue subroutine from your module by typing its name:

    SetValue()

  5. 5

    Press "F5" to run the code and see the cell you typed in the code change to the value you specified.

Tips and warnings

  • The name "SetValue" for the function can be changed to one of your choosing, such as "MyFunction" or "AuntMelinda."

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.