+ Reply to Thread
Results 1 to 2 of 2

Need cell to pre-populate with instructions until value is entered

  1. #1
    Registered User
    Join Date
    01-23-2011
    Location
    ontario, canada
    MS-Off Ver
    Excel 2003
    Posts
    10

    Question Need cell to pre-populate with instructions until value is entered

    I have a form that my users will complete and I'd like to have each cell in the form to pre-populate with instructions on what info should be inputted into the cell. Upon entering the required information, those instructions would disappear as to not prevent any calculations using that data from being completed.

    Is this possible?

    (I hope I've explained myself clearly enough)...

  2. #2
    Registered User
    Join Date
    12-27-2010
    Location
    Bolivia
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Need cell to pre-populate with instructions until value is entered

    Hey boogeyman!
    1) Use textboxes instead of just cells to introduce the data and define the .ControlTipText property for each one, with the text you want to show.
    Something like this:
    Please Login or Register  to view this content.
    2) Add comments to each cell so each time a user moves the mouse over a cell, the comment is displayed. In this case, you will have a red mark at the corner of the cells which will call the attention of your users.

    best regards,
    selopezr

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1