Return to a default state???

[lost and confused in excel-land]

Alrighty, I got the drop down lists working and returning the values they
should....BUT...still having a hitch

B7 contains a drop down list with 3 choices
*Team not present (returns a value of 0 in C7
*Team 1 & 2 (returns a value of 180 in C7)
*Team 1 only (returns a value of 100 in C7)

B8 - B12 have other drop down lists that are dependent on the choice made in
B7 and their corresponding values put in column C as well. (Actually, Column
B# looks at the score in C7 and determines what choices are available, that
was the easiest way I could figure out how to do it, and it works - EXCEPT)

Although the scores in column C are correct, If you change your choice in
B7, the spreadsheet retains the choices made in the drop down list so that it
appears that they were actually chosen until you go into the drop down and
are presented with the new choices based on the score in C7.

Bottom line, I want to be able to set a 'default' text in B# , or better
yet.... a button/key/command at the beginning of the spreadsheet that will
set all cells to blank until something happens in B7.

Also, is there a way to set the dropdown arrow to remain on instead of
mousing over?

Again, many MANY thanks for the help!!

 

[NoodNutt]

G'day Lost & Confused

Q.1
you could insert this into your workbook:

In the VB Editor, insert this into "This Workbook"

Private Sub Workbook_Open()
Sheets("YourSheetName").Select
Range("YourCellRange(s)").Select
Selection = ""
End Sub

This will only work when the workbook is opened.

If you want to use this as a command button:

Insert this into a module

Sub Ive_Changed_My_Mind()
Sheets("YourSheetName").Select
Range("YourCellRange(s)").Select
Selection = ""
End Sub

Q.2

Have you considered using a Combobox which you can insert over the cell,
instead of using data validation dropdowns.

HTH
Mark.