Default Value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

propolis - 28 Jan 2006 13:54 GMT

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'

Signature

propolis

Reply to this Message

Dave Peterson - 28 Jan 2006 14:47 GMT

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

> Hi,
>
[quoted text clipped - 22 lines]
> propolis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=5044
> View this thread: http://www.excelforum.com/showthread.php?threadid=506002

Signature

Dave Peterson

Reply to this Message