Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation
Is there any way I can add a default value of "Hit" to the following
Sandy With .Validation .Delete .Add Type:=xlValidateList, Formula1:="Hit,Miss" .IgnoreBlank = True .InCellDropdown = True End With |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation
Load the cell value with Hit.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sandy" wrote in message ... Is there any way I can add a default value of "Hit" to the following Sandy With .Validation .Delete .Add Type:=xlValidateList, Formula1:="Hit,Miss" .IgnoreBlank = True .InCellDropdown = True End With |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation
Not quite that simple. The original values in the range C20:F40 are loaded
as "Hit". Values that are input into C6:F6 then control the placement of a drop down list. In other words if the value in C6 is such that neither "Hit" nor "Miss" is appropriate then the value of "Neither" is inserted into cell C20 otherwise the validation list below is inserted. (Carried out by a Worksheet_Change event.) The problem is that if the value in C6 is changed, meaning the value in C20 must now be either "Hit or "Miss", the validation drop-down is correctly inserted but the value on display still shows as "Neither" - does this make sense? Sandy "Bob Phillips" wrote in message ... Load the cell value with Hit. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sandy" wrote in message ... Is there any way I can add a default value of "Hit" to the following Sandy With .Validation .Delete .Add Type:=xlValidateList, Formula1:="Hit,Miss" .IgnoreBlank = True .InCellDropdown = True End With |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation
Not to me.
Can you show all the code? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sandy" wrote in message ... Not quite that simple. The original values in the range C20:F40 are loaded as "Hit". Values that are input into C6:F6 then control the placement of a drop down list. In other words if the value in C6 is such that neither "Hit" nor "Miss" is appropriate then the value of "Neither" is inserted into cell C20 otherwise the validation list below is inserted. (Carried out by a Worksheet_Change event.) The problem is that if the value in C6 is changed, meaning the value in C20 must now be either "Hit or "Miss", the validation drop-down is correctly inserted but the value on display still shows as "Neither" - does this make sense? Sandy "Bob Phillips" wrote in message ... Load the cell value with Hit. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sandy" wrote in message ... Is there any way I can add a default value of "Hit" to the following Sandy With .Validation .Delete .Add Type:=xlValidateList, Formula1:="Hit,Miss" .IgnoreBlank = True .InCellDropdown = True End With |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Validation (Drop down list vs simple text length validation) | Excel Programming | |||
Validation (Drop down list vs simple text length validation) | Excel Programming | |||
Validation (Drop down list vs simple text length validation) | Excel Programming |