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).





propolis wrote:
>
> 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'
>
>
>
> --
> propolis
> ------------------------------------------------------------------------
> propolis's Profile: http://www.excelforum.com/member.php...fo&userid=5044
> View this thread: http://www.excelforum.com/showthread...hreadid=506002

--

Dave Peterson