+ Reply to Thread
Results 1 to 4 of 4

Thread: Delete Cell Value but keep the cell formula through VBA and Manually

  1. 11-06-2010, 05:07 AM #1
    dev.amit
    dev.amit is offline
    Registered User
    Join Date
    11-06-2010
    Location
    Banglore, India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Angry Delete Cell Value but keep the cell formula through VBA and Manually

    Hello,

    I have created a excel workbook, it has formulas in the cell.
    I want to allow to user to delete values of the cell which was calculated by the formula but keep the formula in-tact.
    I want to create a Reset button through which I will remove all the values of the cell and keep the formula in the cell.

    Please let me know if I am not clear.

    Thanks for any help you will provide.

    Regards,
    Amit
    Reply With Quote Reply With Quote
  2. 11-06-2010, 05:55 AM #2
    Marcol
    Marcol is offline
    Forum Guru Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    5,590

    Re: Delete Cell Value but keep the cell formula through VBA and Manually

    You either delete the formula or don't.

    What are you trying to do?
    Reply With Quote Reply With Quote
  3. 11-06-2010, 06:09 AM #3
    TMShucks
    TMShucks is offline
    Forum Guru TMShucks's Avatar
    Join Date
    07-15-2010
    Location
    Manchester, England
    MS-Off Ver
    MSO 2003 & 2007
    Posts
    6,228

    Re: Delete Cell Value but keep the cell formula through VBA and Manually

    A formula is dependent on other cells, usually. If you want to clear the value but retain the formula, you will have to clear the content of the other cells.

    Regards
    Reply With Quote Reply With Quote
  4. 11-06-2010, 08:22 AM #4
    vickey.narang
    vickey.narang is offline
    Registered User
    Join Date
    02-26-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Delete Cell Value but keep the cell formula through VBA and Manually

    Hi,
    I have tried creating an example for you. Please check the attachment. I am beginner VBA programmer. See, this is what you want?
    Attached Files Attached Files
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0