Results 1 to 16 of 16

VBA code for 2 buttons that can clear cells in a row then second button to bring data back

Threaded View

Hillster VBA code for 2 buttons that... 11-02-2019, 10:55 PM
BanginMyHeadOnMyDesk Re: VBA code for 2 buttons... 11-03-2019, 05:25 AM
Hillster Re: VBA code for 2 buttons... 11-03-2019, 08:07 AM
BanginMyHeadOnMyDesk Re: VBA code for 2 buttons... 11-03-2019, 09:37 AM
LJMetzger Re: VBA code for 2 buttons... 11-03-2019, 04:19 PM
Hillster Re: VBA code for 2 buttons... 11-03-2019, 09:41 PM
LJMetzger Re: VBA code for 2 buttons... 11-04-2019, 10:26 AM
Hillster Re: VBA code for 2 buttons... 11-03-2019, 09:47 PM
Logit Re: VBA code for 2 buttons... 11-03-2019, 11:53 PM
Hillster Re: VBA code for 2 buttons... 11-04-2019, 07:44 AM
Logit Re: VBA code for 2 buttons... 11-04-2019, 01:19 PM
Hillster Re: VBA code for 2 buttons... 11-04-2019, 01:44 PM
Logit Re: VBA code for 2 buttons... 11-04-2019, 02:09 PM
Hillster Re: VBA code for 2 buttons... 11-04-2019, 03:15 PM
Logit Re: VBA code for 2 buttons... 11-04-2019, 06:34 PM
Hillster Re: VBA code for 2 buttons... 11-08-2019, 09:14 PM
  1. #1
    Forum Contributor
    Join Date
    09-09-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    176

    VBA code for 2 buttons that can clear cells in a row then second button to bring data back

    I need help with 2 form control buttons that i need to clear data out of rows and then click another button to bring the same data back into the rows. I need to perform some back testing and was wondering if there was a VBA code that can be applied to two buttons. Button one, "Clear" and button two, "Retrieve" starting with row 5. I want to be able to remove 1 row at a time. If i click the "clear" button 5 times, 5 rows are gone then I click the Retrieve button 5 times and all the original data comes back and is in the same state as before. On thing I would like to make sure of is when exiting the workbook, all data is retrieved and back on the sheet prior to exit as I want the data to ultimately remain on the sheet. I have attached a work sheet with some example data. Any assistance would be much appreciated.
    Attached Files Attached Files
    Last edited by Hillster; 11-02-2019 at 11:04 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 12-12-2017, 12:49 PM
  2. [SOLVED] Help with code to creat Reset button to clear cells and copy back the original formula
    By rv02 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-30-2015, 02:25 PM
  3. Array Formula Lookup - Bring back Lowest Date + Bring Back Cell Location
    By Matt1998 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-04-2014, 12:08 PM
  4. Replies: 3
    Last Post: 06-05-2012, 04:36 AM
  5. Replies: 2
    Last Post: 02-09-2009, 05:07 AM
  6. Create a button to clear data in certain cells
    By headbanger51 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-07-2008, 03:18 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