Refresh by one click

[mse330]

Hello there,

I am trying make a button where if it is clicked, excel will refresh. I have another cell where it is taking numbers randomly from another sheet so I just want to make a button to refresh the other cell

Thanks in advanced

 

[VoG]

Perhaps

Private Sub CommandButton1_Click()
Me.Calculate
End Sub