Search results

Thanks, that still doesn't do what I need as its a once only function. What I need is to somehow check to see if the cell is blank and then to enter a title text. The sheet will be regulaly used so needs to "reset" itself if the data drop down box is used and then deleted. It seems so simple...

Thanks, but that's not quite what I wanted. Doing what you suggest will put a pop up box somewhere on the workbook only when that cell is selected, what I am looking for is text within the cell before anything is selected or chosen from the list, and then is replaced by whatever text is chosen...

Hello, I'm finding it hard to get the right words to ask the question, let alone search for it, so I hope you can help..... 1. What I am trying to do is to have a cell in Excel display default text, until a drop down list is slected. So the default test is replaced as soon as one of the data...