RANDOMIZE number max lenght 3

[sal21]

How to randomize a number (max lenght 3) when i click on button and assign it to myvar1 (as string dimensioned)

[p45cal]

Assign this sub to a button

Code: Select all

Sub blah()
Randomize
myvar1 = CStr(Application.RandBetween(0, 999))
End Sub

?

[SpeakEasy]

If you want lowest number to be 1, then

randomize
myvar1 = Int(Rnd(1) * 999) + 1

else if you want 0 as trhe lowest number

randomize
myvar1 = Int(Rnd(1) * 1000)

[sal21]

TKS TO THE ALL!