Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formatting
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Formatting
Resolved · High Priority · Version 2007
Reply Wed 2 Nov 2011, 16:24Delegate Tina said...
Tina has attended:
Excel Intermediate course
Excel Advanced course
Powerpoint Intermediate Advanced course
Time Management course
Project Management course
Formatting
Hi,
I want to insert a small tick box into a questionnaire document that I am creating. How do I do this?
Thank you,
Tina
For upcoming training course dates see: Pricing & availability
RE: Formatting
http://office.microsoft.com/en-au/excel-help/add-a-list-box-or-combo-box-to-a-worksheet-HP010236681.aspx
Hi Tina,
Please find attached a link that will step you through how to create list box. This is reasonably advanced and it would help if you had some VBA experience to create that.
Another options you use a combo box and they are much easier to create.
Step One:
Create your list. If you are using 2007 and the list is on another sheet than the question then you will need to name that list. To do this use the NAME BOX.
Step Two:
Go do DATA VALIDATION and select LIST and the in the SOURCE find your list or enter =plusthenameofyourlist
This will add a drop down combo box to the cell you are working on.
I hope that helps?
Thanks
Paul
|