Hi,

I would like to use a command button for this excel formula
=randbetween(1,100)


Try:

'=============
Private Sub CommandButton1_Click()
Selection.Formula = "=RandBetween(1,100)"
End Sub
'<<=============


---
Regards,
Norman