title: Text box prompt text in Excel VBA
body: <p>You know how sometimes you see text in an input field prompting for an answer? When you click it, it goes away, but comes back if you deselect without having typed anything.</p>
  
  <p>How do I accomplish this in an Excel text box? Can this be done at all?</p>
  
  <p>I think I could accomplish this if I attach a click macro to the text box and the macro can be able to tell what text box was clicked, but the problem with the click macro is it won't let you select the object first, so you have no idea what was clicked. And I don't want to hard code the text box name in the click macro code.</p>