Default Value

[propolis]

Hi,

I have a cell that uses validation to return a number.

A B
a = 1
b = 2
c = 3
etc
etc
Select=0

What I want to do is that when I open the workbook, this cell will be
default to select that returns 0.

Also, how can I add a Reset but, that if a user has made a selection,
he clicks the reset button to set the value back to 'Select' which will
return '0'

 

[Dave Peterson]

I'm not sure if I understand, but if you just want to clear a cell (or a group
of cells), you can use a macro:

option Explicit
sub Auto_Open()
with worksheets("sheet99")
.range("a1").clearcontents
.range("b3:b12").clearcontents
.range("c1,d3:d4,q9").clearcontents
end with
end sub

Just showing how you can specify the range.

Remember to use the correct worksheet name (I used sheet99).