Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel tables and Form controls
|
|
|
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. |
Excel tables and Form controls
Resolved · Low Priority · Version 2007
Reply Thu 8 Sep 2011, 16:30Delegate Deborah said...
Deborah has attended:
Excel Intermediate course
Word Intermediate course
Excel Advanced course
Word Advanced course
Excel tables and Form controls
Can you use 'Form Controls' in an excel database formatted as a table?
For upcoming training course dates see: Pricing & availability
RE: Excel tables and Form controls
Hello Deborah,
Thank you for your question regarding using Form controls on an Excel database formatted as a table.
The answer is 'Yes' you can. I created a table then added a spin button to one of the cells within the table and it worked perfectly. I didn't try anything else... but if that worked then other Form controls should work too.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
RE: Excel tables and Form controls
Hello Deborah,
Thank you for your question regarding Form Control.
Form Controls can be used on any sheet type. It depends on what form control you are intending to use and for what purpose? If you let us know how you want to apply it we can have a look. But in answer to your question yes form controls are usable in Lists/Tables/Pivots etc..
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
Reply Thu 15 Sep 2011, 15:22Delegate Deborah said...
RE: Excel tables and Form controls
I've created a database in Excel and want to use the drop down boxes to limit choice of information that can be inserted into each column. As several people will be using it to input data I want to make sure its unified so that when we need to filter it for info it works!
Can i do this in excel? If so how?
Thanks.
RE: Excel tables and Form controls
Hello Deborah,
When you attended the advanced Excel course you were shown how to create drop-down lists using Data Validation. Would this not work for you?
If you have a need for any special drop-downs that link to formulas etc. then I suggest you send me a sample file showing me exactly what you would like to do, and then I will formulate a solution for you.
I think that the Data Validation list system will work for you and if it does, then please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
|