+ Reply to Thread
Results 1 to 2 of 2

How can I add values in 2 cells using a command button

Hybrid View

Guest How can I add values in 2... 07-17-2005, 03:05 AM
Guest Re: How can I add values in 2... 07-17-2005, 03:05 AM
  1. #1
    Dr.H.Subramanian
    Guest

    How can I add values in 2 cells using a command button

    How can I add values in 2 cells using a command button
    Example - Values in A1 and A2 to be added and shown in A3 at the click of a
    command button (ADD) which is inserted from the tools box.

  2. #2
    JE McGimpsey
    Guest

    Re: How can I add values in 2 cells using a command button

    One way:

    Public Sub CommandButton1_Click()
    Range("A3").Value = Range("A1").Value + Range("A2").Value
    End Sub

    In article <08531054-327C-4A61-BBAF-CD302616D5C6@microsoft.com>,
    "Dr.H.Subramanian" <DrHSubramanian@discussions.microsoft.com> wrote:

    > How can I add values in 2 cells using a command button
    > Example - Values in A1 and A2 to be added and shown in A3 at the click of a
    > command button (ADD) which is inserted from the tools box.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1