Auto recalculate?
Try F9.
Tim C
"Lee Harris" wrote in message
...
I have a nifty sheet that does some automated play calling for a game, and
it works fine if I just select a cell (empty one) and hit delete - it
re-randomises and picks a play
however, I tried adding a button and code to make it a clickable button,
but it doesn't seem to work. In addition, I cannot even remember how I
added the button or code (I got into VBA with Alt-F11 but am not sure how
I linked the code to the button, or whether somethings gone wrong)
I have other files with the same clickable button and exactly the same
code and it works fine.
If possible I would also like to be able to have a button on a separate
tab in the same file also randomising everything via the same recalculate
method if I can do that..
any help greatly appreciated. Can send file too if you like, only 53 KB
zipped up.
Private Sub CommandButton1_Click()
Calculate
End Sub
|