Couple of hopefully easy questions

T

TeddyTash

Hey all, hope you can help with these two minor things.

Question 1:
Is it possible to:
In a contest between 2 people, first to reach 100pts.
A1 is "Adam" (Player 1's Name)
A2 is "Mary" (Player 2's Name)
B1 is Player 1's score
B2 is Player 2's score

If B1 or B2=100, then F1 displays a message such as "Game Over
'Players Name' has reached 100 pts"

Hope this can be done as it would be a nice feature.


Question 2:
Is it possible to:
Make it so that a cell will only allow you to enter "Good", "Bad" o
"Average" and make it refuse anything else. (of course it would have t
be able to be left blank until filled in)


Thanks in advance.

~Tedd
 
A

Anne Troy

D

Don Guillett

#1 right click sheet tab>view code>insert this>SAVE
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$1" Or Target.Address = "$B$2" Then
If Target.Value >= 100 Then MsgBox "Game Over"
End If
End Sub

#2 menu data>validation
 
S

Stefi

Hi Teddy,
Question 1:
Is it possible to:
In a contest between 2 people, first to reach 100pts.
A1 is "Adam" (Player 1's Name)
A2 is "Mary" (Player 2's Name)
B1 is Player 1's score
B2 is Player 2's score

If B1 or B2=100, then F1 displays a message such as "Game Over:
'Players Name' has reached 100 pts"
Click to expand...

In cell F1 enter
=IF(OR(B1>=100;B2>=100);"Game over: " & IF(B1>=100;A1;A2) & " has reached
100 pts";"")
Question 2:
Is it possible to:
Make it so that a cell will only allow you to enter "Good", "Bad" or
"Average" and make it refuse anything else. (of course it would have to
be able to be left blank until filled in)
Click to expand...

1. Select the cell!
2. Data/Validation/Settings(first tab)
3. In Permitted(first field) select List
4. In Source type Good, Bad,Average
5. Beside the cell (if selected) you see a down-arrow, clicking on it you
will see the choice, click on the desired option!

Have a nice game!
Stefi
 
Top