RandBetween code in VB (Excel 2010)

[teamyoko]

I have to create a code in excel that requires the user to select a number between 1 and 100 and tell the user to guess the value of the randomly generated number and to let the user know if it is correct, too low, or too high.

The game requires a button to be created in a procedure labeled "play the high low game"

I know I need to use WorksheetFunction.RandBetween(1,100) but I don't know what else needs to be done.

Please help.

[Norie]

You don't need to use RandBetween, you can use VBA's Rnd.

Please Login or Register  to view this content.

[abousetta]

This should do the trick:

Please Login or Register  to view this content.

You can extend this to using a userform instead of an input box, etc.

abousetta