Variable data validation

[Mika]

Hi

I have a simple data validation in a range, but I would like that each
of those cells initially shows something like: "choose option", and of
course when clicked that cell, I want to have in the list only the
options (say A,B,C) without the "Choose option" in the list.

Is that possible? (I can't use any vba programming)

Cheers
mika

 

[Ron Rosenfeld]

Hi

I have a simple data validation in a range, but I would like that each
of those cells initially shows something like: "choose option", and of
course when clicked that cell, I want to have in the list only the
options (say A,B,C) without the "Choose option" in the list.

Is that possible? (I can't use any vba programming)

Cheers
mika

Without VBA, you could use Data Validation to show an Input Message, which would show when the cell is selected; and also to set up a drop-down box to show your allowable choices.

 

[Mika]

Without VBA, you could use Data Validation to show an Input Message, which would show when the cell is selected; and also to set up a drop-down box to show your allowable choices.

Thanks Ron,

Yes I know, problem is that that message only appears when the cell is
selected, and I want to draw attention to the cell ....

Mika

 

[DanielCo]

Hi
You may enter "Choose option" in the cells, and then add data
validation.
Daniel

 

[Ron Rosenfeld]

Thanks Ron,

Yes I know, problem is that that message only appears when the cell is
selected, and I want to draw attention to the cell ....

Mika

Without VBA all you can do is insert that phrase to the cell BEFORE you set up the data validation. But that phrase will be wiped out as soon as you select anything in the list, and will not return if you delete the contents of the cell.

 

[GS]

Normally, I'd go with Ron's suggestion when designing a wks to be used
as a form template where user input is restricted to unlocked cells and
the wks is protected. Users would be instructed to use the Tab key for
navigation because the wks is designed so as to follow the preferred
order of input. In this case, the message displayed could have input
instructions (or input examples) for the user at that point in filling
out the form.

I often implement similar to DanielCo's suggestion. This approach makes
sense since the validation won't take effect until the user tries to
change the cell contents. The possible downside to this is if the user
changes their mind about the selected choice; they are left with
leaving the cell empty or choosing another option.

I often include ConditionalFormatting that 'flags' the required input
cells with red (fill or text) or some other eye-catching color to draw
attention to those cells. As the user enters data and moves on, the CF
removes the color.

HTH

 

[Mika]

Hi Guys

Thanks for your replies, I will go by inserting the phrase in the
cells before the validation...

cheers
mika

 

[CellShocked]

Message, which would show when the cell is selected; and
also to set up a drop-down box to show your allowable choices.

Thanks Ron,

Yes I know, problem is that that message only appears when the cell is
selected, and I want to draw attention to the cell ....

Mika

You can make a comment, and then 'turn it on' all the time