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

  1. #6
    Forum Contributor
    Join Date
    09-09-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    176

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

    Thanks for the fast responses guys.... LJMetzger, I am getting a very interesting result with your copy of the work sheet with VBA in it... when I pasted your code into my master Workbook, then added the form control buttons, click them. it keeps opening your copy of the example work sheet you posted here. It does it even if i exit out of your example work sheet.... I don't even know how that could possibly happen. Lol I inserted a Module in my workbook, copy / pasted your code into it. clicked the "Clear" button and row 5 data remains in the worksheet but your example copy pops up with all of Row 5 data removed... Not a usable function but cool to see. Also tried clicking the "Restore Original Data" button... Not a good idea as it locked up Excel for at least 15 minutes until I hit ctrl Alt Delete to End Task... The concept is on point, just does not work in my workbook. Seems awesome in the example though, nice work!!
    Last edited by Hillster; 11-03-2019 at 09:43 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