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

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