Feature Summary

Form controls are used to add form elements such as buttons, check boxes, drop-down lists, etc., to a worksheet for creating interactive forms and data entry interfaces.

Feature Description

Feature Dimension Description
Membership Restriction No membership restriction
Version Restriction No version restriction

Steps

Insert Form Controls

Feature Entry

"Tools" tab → "Developer Tools" option → "Developer Tools" tab

  1. Click the Developer Tools button in the Tools tab to open the Developer Tools tab
  2. Select the desired control in the "Form Controls" area:
  • Button
  • Check Box
  • Option Button
  • List Box
  • Combo Box
  • Scroll Bar
  • Other Controls

3.Drag on the worksheet to draw the control

imageimage

Notes

  • Controls can be linked to cells to retrieve values
  • Suitable for creating data entry forms