+ Reply to Thread
Results 1 to 5 of 5

Worksheet Change? Use a formula cell as input and then revert back to original formula...

  1. #1
    Forum Contributor
    Join Date
    10-30-2010
    Location
    Kansas, USA
    MS-Off Ver
    Excel 2010
    Posts
    100

    Worksheet Change? Use a formula cell as input and then revert back to original formula...

    QTY 100
    PRICE $5.00
    TOTAL $500.00



    So I have a worksheet where the inputs are QTY and PRICE, and the TOTAL being the formula QTY * PRICE..
    I would like to be able to input a value into the TOTAL cell and have it change the PRICE cell's .value by dividing the value entered by the QTY, then reverting back to its original formula..

    I've been experimenting with worksheet change but i'm too out of practice with vba lately..

    any help is much appreciated

  2. #2
    Forum Guru
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,788

    Re: Worksheet Change? Use a formula cell as input and then revert back to original formula

    Maybe :
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    2007
    Posts
    3,301

    Re: Worksheet Change? Use a formula cell as input and then revert back to original formula

    Hi there,

    Try the Worksheet_Change event macro where I've assumed the following cell references (change to suit): QTY = B2, PRICE = B3 and TOTAL = B4

    Please Login or Register  to view this content.
    Regards,

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  4. #4
    Forum Contributor
    Join Date
    10-30-2010
    Location
    Kansas, USA
    MS-Off Ver
    Excel 2010
    Posts
    100

    Re: Worksheet Change? Use a formula cell as input and then revert back to original formula

    Thank you @karedog and @Trebor76! Both of your suggestions work great! I appreciate your time to help me!

    Thanks!

  5. #5
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    2007
    Posts
    3,301

    Re: Worksheet Change? Use a formula cell as input and then revert back to original formula

    You're welcome. Thanks also for marking the thread as solved and for the rep

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change cells back to original conditions by double clicking another cell
    By Bonnister in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-14-2013, 10:21 AM
  2. Help: Reset input data back to original
    By jasonj427 in forum Excel General
    Replies: 5
    Last Post: 01-22-2013, 01:49 AM
  3. Replies: 3
    Last Post: 12-20-2012, 06:16 AM
  4. Replies: 11
    Last Post: 07-06-2012, 09:08 AM
  5. Replies: 2
    Last Post: 11-24-2009, 12:31 AM
  6. Revert back to original sort
    By Michael in forum Excel General
    Replies: 2
    Last Post: 04-10-2006, 12:00 PM
  7. Replies: 0
    Last Post: 04-17-2005, 04:07 AM

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