UserForms staying functional

**wmorrison49** · 10-09-2007, 11:23 AM

Hi everyone,
I am trying to make a little game for a friend of mine. It picks a random number 1-1000 then he gets 10 chances to guess the number. After each guess, it tells him if the number is higher or lower. I have a userform that you put it your first guess, hit a button, and it tells you if the number is higher or lower. All the guess blanks and buttons are on the same UserForm. However, after you push the first button, the UserForm doesn't work anymore. How do I get it to stay functional the whole time?

Thanks in advance.

**wmorrison49** · 10-09-2007, 11:36 AM

Actually, I am having problems with the UserForm reading the data right off the UserForm too. I have attached what I have so far. Feel free to make changes or whatever you want. Thank you guys very much.

**royUK** · 10-09-2007, 12:21 PM

You don't declare Magicnumber as a variable and I can't see where you actually give MagicNumber a value. You also place the response to Guess2 in Response1. This works

Please Login or Register  to view this content.

**wmorrison49** · 10-09-2007, 01:02 PM

The code works great, so thanks. For my own understanding though, there are a couple things I was hoping you could clear up.
1) What does Option Explicit do?
2) What does With Me do?

**royUK** · 10-09-2007, 01:12 PM

Option Explicit basically forces you to declare your variables, for a fuller explanation read this:
http://www.excel-it.com/clear_code.htm

Me is a keyword that refers in this case to the UserForm. In a workbook event or WorkSheet event it would refer to the Workbook or worksheet

**wmorrison49** · 10-09-2007, 01:17 PM

I have used Me before to hide UserForms (Me.Hide), so I have SOME familiarity with it, but not a lot. What does the With in front of it denote? Also, is there any easy way for it to prompt the user if they want to play again, and then reset everything?

**royUK** · 10-09-2007, 01:29 PM

By using With Me you don't need to type Me for each object, note .Guess1, .Response1 etc

To offer the chance to play again, you could add a Commandbutton and simply close the userForm then reload it

Please Login or Register  to view this content.

Or use it to loop through the TextBoxes 7 clear them, this would keep the same MagicNumber

Please Login or Register  to view this content.

**wmorrison49** · 10-09-2007, 01:52 PM

That helps a lot. Thanks!

**royUK** · 10-09-2007, 02:03 PM

No problem Why not post the finished game back here?

If you go with the loop to clear the textboxes you could store the number of attempts in a label & update it each time the user has another go

Please Login or Register  to view this content.

Remember to delete the caption in the label initially.

**wmorrison49** · 10-09-2007, 03:44 PM

I ended up just going with the form reload. Just seemed easier. Here's the game! It's not super slick or anything, Andy Pope style, but it does the job.

UserForms staying functional

LinkBack

Thread Tools

Rate This Thread

Display

UserForms staying functional

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions