+ Reply to Thread
Results 1 to 2 of 2

Change Cell Value

  1. #1
    Registered User
    Join Date
    04-07-2008
    Posts
    1

    Change Cell Value

    I need a macro/function that will analyze the value of one cell, and if that cell is 0, then it will change another cell to 0. I have to do it this way because I want people to be able to input there own values in both cells if necessary, but if they enter zero in one I want to make sure the other reflects that accordingly. Can you help???

    Thanks!!!

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello shguser,

    Welcome to the Forum!

    Here is macro that will make sure both cells are zero if the user enters zero into either cell. You can the cells' addresses in the code to match the ones you are using. The changes are marked in red.
    Please Login or Register  to view this content.
    How to Save a Worksheet Event Macro
    1. Copy the macro using CTRL+C keys.
    2. Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
    3. Left Click on View Code in the pop up menu.
    4. Paste the macro code using CTRL+V
    5. Save the macro in your Workbook using CTRL+S

    As a new member please take so time to familiarize yourself with the Do's and Don'ts here in the Forum, just click on the link below...

    Forum Rules

    Sincerely,
    Leith Ross

+ 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