default value

**hustla7** · 08-19-2006, 11:44 AM

any way of entering default value's into cells??

**raypayette** · 08-19-2006, 11:57 AM

Of course. It depends on your requirements, for example:
Sub auto_open()
Worksheets("Sheet1").Activate
Cells(1, 1) = 5
End Sub

**hustla7** · 08-19-2006, 12:06 PM

sorry, i didnt quite understand that- i want to put a default value into cell A5 which would be A4+1 and so on into the rest of the A column...can u help with that please?
Thanks a lot

**raypayette** · 08-19-2006, 12:07 PM

Enter =A4 + 1 in A5!!!

**hustla7** · 08-19-2006, 12:14 PM

Sorry, I didnt make the problem clear enough, i also have a validation in the column saying that no two values should be the same- if i enter a formula into the cell- the validation doesn't work- i need to be able to have both working---thanks a lot for ur help!

**davesexcel** · 08-19-2006, 12:25 PM

Adding to raypayette's code

Private Sub Workbook_Open()
Worksheets("Sheet1").Activate
Cells(1, 1) = 5
Range("A1:A11").Select
Selection.DataSeries Rowcol:=xlColumns, Type:=xlLinear, Date:=xlDay, _
Step:=1, Trend:=False
Range("A1").Select

End Sub

this will set the cells each time the book is open, may have to use a dynamic range check out this site for that
http://www.contextures.com/xlNames01.html#Dynamic

Bob Phillips · 08-19-2006, 01:00 PM

Validation will work that way. Enter =A4+1 in A5 as suggested will not alter
the validation, will just be checked against it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"hustla7" <hustla7.2csov4_1156004107.2424@excelforum-nospam.com> wrote in
message news:hustla7.2csov4_1156004107.2424@excelforum-nospam.com...
>
> Sorry, I didnt make the problem clear enough, i also have a validation
> in the column saying that no two values should be the same- if i enter
> a formula into the cell- the validation doesn't work- i need to be able
> to have both working---thanks a lot for ur help!
>
>
> --
> hustla7
> ------------------------------------------------------------------------
> hustla7's Profile:
http://www.excelforum.com/member.php...o&userid=37760
> View this thread: http://www.excelforum.com/showthread...hreadid=573417
>

Gord Dibben · 08-19-2006, 01:20 PM

hustla

If using the DV formula is: =COUNTIF($A$1:$A$50,A1)=1
or similar...........................

Remember, that Data Validation is in effect only when the cell value is changed
by the user. It does not catch changes made by VBA procedures, or as a result
of a calculation in a formula. Also, Data Validation does not apply to changes
made when the user pastes data in to the range.

Gord Dibben MS Excel MVP

On Sat, 19 Aug 2006 12:14:18 -0400, hustla7
<hustla7.2csov4_1156004107.2424@excelforum-nospam.com> wrote:

>
>Sorry, I didnt make the problem clear enough, i also have a validation
>in the column saying that no two values should be the same- if i enter
>a formula into the cell- the validation doesn't work- i need to be able
>to have both working---thanks a lot for ur help!