Closed Thread
Results 1 to 3 of 3

Thread: simple vba code

  1. #1
    Registered User
    Join Date
    01-04-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    13

    simple vba code

    hi all i am new to programming in excel

    For example user enters the value 1 in A1 and 2 in B2 The answer should be in 3 in C1

    How to write this code ? Also is there any way where i can let the user copy the VALUE from the result (C1) into another Sheet
    in case if am using + Sign to obtain the result in C1 instead of writing a VBA Code

    Basically i am looking for the user to in put data in A and B and the result should come in C and the user should copy the value
    from C into another sheet. The user should not have access to the formula.

    If i have to do the same addition in the next 100 rows in sheet 1 and sheet 2 what will be the VBA CODE

    Many Thanx

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2007
    Posts
    5,953

    Re: simple vba code

    Hi Grk_chakri,

    Please take a moment to read the forum rules (link in my signature below), and then amend your thread title to be descriptive of your problem.

    This thread is also cross-posted on another site. Carefully read all of the rules prior to posting again.

    Thank you.
    Last edited by Paul; 01-06-2012 at 12:22 AM.

  3. #3
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2007
    Posts
    5,953

    Re: simple vba code

    Thread being closed as user has started a new one with a proper title and link to cross post.

Closed 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.2.0