Forms - Prompts for a List using Data Validation

[Howie_B]

I am creating a business form using excel 2007. I have fields that I would like to have a drop down list in. I would like for that field to have a prompt message that appears without having to click on the cell first. So that if you opened the sheet say cell B2 would say "Yes or No" and then if you clicked on the cell there would be a drop down and you would choose your response which would replace the prompt.

I have created the named range on a separate sheet that I plan to hide, and I know how to create a drop down list using data validation, but I can't figure out how to create the prompt.

Thanks in advance for the help.

 

[energman58]

If you enter yes or no and then put in the data valaidation then it stays with the original value but when you try and enter data the validation works and forces you to pick yes or no. You would have to reset it with VBA though if you need to.

 

[Howie_B]

thanks for the reply.

how would i go about making it say "Yes or No" anytime the cell is blank?

 

[energman58]

I cant think how you would do that as the cell would not be blank then would it? You maybe could do it by having a conditional format and a background but I would need to think about how to do that