VBA code Help

[Joneye]

Im looking for to go in cell A1 of a workbook, all the code is required to do is count 1 - 100 over a time say 100 seconds.

If possible can the code count up, then count down and keep repeating. But have a stop / off button?

Whats it for, im looking to automate a graph via it.

PS many thanks in advance.

 

[kpark91]

Hi, Joneye. You probably have done it right since you were using buttons in the first place but just to be sure,
to define the click event, you must first create the command button
then double click on the button.
Then it will show you the code of

Private Sub buttonname_Click()
    'copy paste code
End Sub

The code I have written requires two buttons. one named btnStart and the other named btnStop.

1) Anyways, what kind of problem are you having with the code?
Is it not updating the value at all?

2) Are you running any other macros with this macro? If so, are you turning application.screenupdating off? If so, you will need to turn it back on when you're updating the value of cell A1.

 

[Joneye]

Ill check it when home, but I think im good for now, many thanks for all your help, any issues ill pop over a screen shot.