R
rjmachado3
I get de following macro associated in a command button:
Private Sub cmdIniciar_Click()
Sheets("Folha1").Select
Do
tryes = tryes + 1
Sheets("Folha1").Range("b10").Value = tryes
If Sheets("Folha1").Range("b14").Value = True Then
End
End If
Loop
End Sub
The purpose is to produce one random aleatory data list, the problem
is that Excel 2003 refreshes permanently the aleatory cell data
witch makes consume all processor bandwidth. Want I need is that the
active worksheet "Folha1" only refreshes when the variable "tryes"
gets increments for 100 to 100 interactions (after only 100, 200, 300,
400, etc. interactions.) In this way I would economize the processor
bandwidth. I hope that I should be the best explicit as possible.
Sorry for the poor English. thanks for everyone that can help me!
Private Sub cmdIniciar_Click()
Sheets("Folha1").Select
Do
tryes = tryes + 1
Sheets("Folha1").Range("b10").Value = tryes
If Sheets("Folha1").Range("b14").Value = True Then
End
End If
Loop
End Sub
The purpose is to produce one random aleatory data list, the problem
is that Excel 2003 refreshes permanently the aleatory cell data
witch makes consume all processor bandwidth. Want I need is that the
active worksheet "Folha1" only refreshes when the variable "tryes"
gets increments for 100 to 100 interactions (after only 100, 200, 300,
400, etc. interactions.) In this way I would economize the processor
bandwidth. I hope that I should be the best explicit as possible.
Sorry for the poor English. thanks for everyone that can help me!