+ Reply to Thread
Results 1 to 3 of 3

Reset button code

  1. #1
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Reset button code

    Hello
    I have a button in my worksheet that does clear the data once I click the button.
    So, I have this code (see below). I want to understand clearly why there if a Range (F7).Select. In my worksheet I don't have F7 as range.
    Do I really need this with the rest of the code?

    Please Login or Register  to view this content.

    Thanks

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Reset button code

    If you don't want the macro to select Cell F1 after running the code, then you can remove it


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Re: Reset button code

    Mmmm.... i want to inderstand why the F1 was there in the first place.

+ 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. Create running stopwatch/timer with 1 button (start/stop). No reset button.
    By leeroy2612 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-26-2021, 12:59 AM
  2. Detect the VBE Stop/Reset button from COM/ATL code
    By mc2323 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-28-2017, 10:46 AM
  3. [SOLVED] I need to create a reset button that will reset rows containing a specific value
    By odin78 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 04-03-2016, 02:11 PM
  4. [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
  5. VBA code doing the same as manually pressing the "Reset" Button
    By excel_drives_crazy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2015, 05:58 PM
  6. Reset button with code not working
    By v4mns in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-07-2015, 12:18 PM
  7. Reset Macro Button Code in combination with a Loop
    By tnuis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2013, 06:09 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