Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Feb 2001
    Location
    Toronto, Ontario, Canada
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Text Box with prompt (PowerPoint 2000)

    Is there a way to replicate the Text Box with the disappearing text that appears on slide layouts - the most obvious being the one that prompts the user to "Click to add title"? I'd like to be able to do this in Excel. When the user selects the text box the text is unaffected, but when the user clicks on the text itself it disappears only to re-appear if the user does not type anything.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Text Box with prompt (PowerPoint 2000)

    That kind of text box is custom made for PowerPoint, but you can simulate is to some degree. I have attached a zipped Excel workbook with a text box on a userform; if the text box is empty, its border is visible, but if the text box contains text, it is borderless. View the code behind the userform to see how it is done.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •