Number Guessing game Help VBA

[allisbad04]

Hello, i am fairly new to vba and I have been trying to make a guessing game with these terms:
Have the computer randomly select a number between 1 and 100 using a “Reset”
button. Create a separate button “Guess” to prompt the user to guess the number. Let the player
know if their guess is too high or too low. If their guess is within two of the mystery number, do not
tell them if their guess was too high/low but output “Close but no cigar. Try again. Display the players guesses in column 1 and if it is too high or low in column 2.

I have been trying many different codes but I can not get it right can someone please show me how to code for this? thank you.

 

[NateSC]

Can you post what you do have? Which part isn't working?

 

[Joe4]

Duplicate to: VBA guessing game

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

Also, as per rule 7, users are only allowed one account on this board, so I am locking this account.