Setting a Default Value in Excel
 

How do I set a default value in certain cells? The cells are already
validated and I would like to have the default value be one of the validation
values.

Hi
this would be only possible using VBA

--
Regards
Frank Kabel
Frankfurt, Germany
"g" schrieb im Newsbeitrag
...
How do I set a default value in certain cells? The cells are already
validated and I would like to have the default value be one of the
validation
values.

What is VBA?

"Frank Kabel" wrote:

Hi
this would be only possible using VBA

--
Regards
Frank Kabel
Frankfurt, Germany
"g" schrieb im Newsbeitrag
...
How do I set a default value in certain cells? The cells are already
validated and I would like to have the default value be one of the
validation
values.

Hi
Visual Basic Applications (macros)

--
Regards
Frank Kabel
Frankfurt, Germany
"g" schrieb im Newsbeitrag
...
What is VBA?

"Frank Kabel" wrote:

Hi
this would be only possible using VBA

--
Regards
Frank Kabel
Frankfurt, Germany
"g" schrieb im Newsbeitrag
...
How do I set a default value in certain cells? The cells are already
validated and I would like to have the default value be one of the
validation
values.

Couldn't he set up an if statement?


"Frank Kabel" wrote:

Hi
Visual Basic Applications (macros)

--
Regards
Frank Kabel
Frankfurt, Germany
"g" schrieb im Newsbeitrag
...
What is VBA?

"Frank Kabel" wrote:

Hi
this would be only possible using VBA

--
Regards
Frank Kabel
Frankfurt, Germany
"g" schrieb im Newsbeitrag
...
How do I set a default value in certain cells? The cells are already
validated and I would like to have the default value be one of the
validation
values.

Hi
but this would not be an default value?

--
Regards
Frank Kabel
Frankfurt, Germany
"hagen" schrieb im Newsbeitrag
...
Couldn't he set up an if statement?


"Frank Kabel" wrote:

Hi
Visual Basic Applications (macros)

--
Regards
Frank Kabel
Frankfurt, Germany
"g" schrieb im Newsbeitrag
...
What is VBA?

"Frank Kabel" wrote:

Hi
this would be only possible using VBA

--
Regards
Frank Kabel
Frankfurt, Germany
"g" schrieb im Newsbeitrag
...
How do I set a default value in certain cells? The cells are
already
validated and I would like to have the default value be one of the
validation
values.

When do you want the default value to appear?

If you want it to appear when data is entered in a row, you could use
programming. Or, enter the default value in each cell, and hide the
value with conditional formatting. Set it to change font colour when
other data is entered in the row. There are examples he

http://www.contextures.com/xlCondFormat03.html


g wrote:
How do I set a default value in certain cells? The cells are already
validated and I would like to have the default value be one of the validation
values.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html