Results 1 to 3 of 3

Thread: Need urgent help please - button to run macro
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jul 2011
    Posts
    90
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Need urgent help please - button to run macro

    Hi there need some urgent help please to finalise a spreadsheet.

    I have a load of data entry boxes and then a button assigned to a macro to do some goal seek type calculations over several tabs and it calculates a resulting figure in the same front sheet in say cell F10.

    What i want to do is have the figure in F10 reset to ZERO when people start playing around with the data entry boxes, until they press the button to run the macro. Otherwise the figure in F10 will be wrong based on the data entry boxes (until the macro has been run)

    I'm sure this will be dead easy for an expert

    Many thanks in advance

  2. #2
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,900
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    7 Thread(s)

    Default Re: Need urgent help please - button to run macro

    Would it not be simpler to reset the value when the macro is run ? First line of macro could be ..
    Code:
    Range("F10") = 0
    Last edited by Yongle; Sep 4th, 2019 at 04:36 PM.

  3. #3
    Board Regular
    Join Date
    Jan 2007
    Posts
    1,203
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need urgent help please - button to run macro

    Why not use the Worksheet Change event to reset the value?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •