#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2002
    Posts
    7
    Rep Power
    0

    Arrow excel visual basic


    I had one question, how do i plus a number from excel cell for example A1.

    A1 number is now 30, if i add a code in visual basic by clicking a command button, it will add 1 to 31. (excel97)
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2002
    Posts
    7
    Rep Power
    0
    Solved:

    Private Sub Button1_Click()
    Range("A1").Activate
    ActiveCell.Value = ActiveCell.Value + 1
    End Sub

IMN logo majestic logo threadwatch logo seochat tools logo