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

Originally Posted by shg

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

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