+ Reply to Thread
Results 1 to 6 of 6

Descriptive Caption for Excel Form

  1. #1
    Registered User
    Join Date
    06-26-2017
    Location
    London
    MS-Off Ver
    365
    Posts
    16

    Descriptive Caption for Excel Form

    Hello,

    I am in the process of creating an Excel form to collect client information (City, Country, Website, Contact Details etc.). I have seen in other forms in the past (see example attached) that you can add a text caption to help end users fill in the correct information and that one click will clear all text to help them add the correct data. I cannot seem to find out how to add this for myself on Excel.

    For example in this form I would have a section for main contacts and job title, and I would like to add in small italic font into that cell something like "e.g. Mr John Smith, CEO" just to ensure users are filling in the correct info.. There are many more criterias where I would like to add a similar capability to guide users.

    Is there a developer function similar to check-boxes where I can easily add this? I'm reluctant to simply write the text into the cell as there's a possibility I may want to link data to a separate worksheet at a later stage, so would not want to example captions to transfer across.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,658

    Re: Descriptive Caption for Excel Form

    It requires VBA. Are you comfortable with that?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    06-26-2017
    Location
    London
    MS-Off Ver
    365
    Posts
    16
    Quote Originally Posted by shg View Post
    It requires VBA. Are you comfortable with that?
    Hi,

    I've not used VBA before but willing to give it a try to fulfil this task. Would this task even be that complex for a beginner?

    Thanks

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,658

    Re: Descriptive Caption for Excel Form

    See if the attached does what you want.
    Attached Files Attached Files
    Last edited by shg; 08-30-2017 at 03:34 PM.

  5. #5
    Registered User
    Join Date
    06-26-2017
    Location
    London
    MS-Off Ver
    365
    Posts
    16

    Re: Descriptive Caption for Excel Form

    Hi Shg,

    This does exactly what I want. Thank you. I would be keen to understand how this was created as there are more that I would like to add to my own form?

    Thanks

  6. #6
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,658

    Re: Descriptive Caption for Excel Form

    Anything you put on the second tab will appear on the first tab if you clear the same cell on the first tab.
    Last edited by shg; 08-30-2017 at 03:14 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to update form label caption based off selection
    By cameron213 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2014, 03:22 PM
  2. Moving User Form Caption
    By LoveCandle in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-20-2010, 10:12 AM
  3. Possible to change Form caption to cell value or variable
    By JP Romano in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-24-2009, 04:36 PM
  4. User Form Caption controls beyond formatting
    By Vacation's Over in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-01-2005, 11:05 AM
  5. [SOLVED] Update the time in a form caption
    By jarosinski2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-08-2005, 03:06 AM
  6. Form Caption Logo, How?
    By WTG in forum Excel General
    Replies: 1
    Last Post: 03-01-2005, 09:06 AM
  7. Form Caption Logo, How?
    By WTG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2005, 08:06 PM
  8. Form Caption Logo, How?
    By WTG in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-27-2005, 10:06 AM

Tags for this Thread

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