Using a Data Form is an easy way to display or enter all information in one row in a table or in a range, without scrolling or moving between columns. In this section we explain the Shape object & OLEObject object, and illustrate using ActiveX Controls, Form controls & AutoShapes in an Excel Worksheet. You may use a Form individually, or combine them in various manners for your suitability. Type of forms which can be created in Excel include: Data Form, Worksheet containing Form controls & ActiveX controls, & UserForms in VBA. You can create various types of Forms in Excel, which are documents having a standard structure & format & help to organize, capture & modify data. Illustrating Auto Shapes, Add a connector ScrollBar & SpinButton Controls - Form Control or ActiveX Control
Option Button - Form Control or ActiveX Control
List Box & Combo Box - Form Control / ActiveX Control Illustrating Form Controls, ActiveX Controls & AutoShapes:īutton (Form Control) Command Button (ActiveX Control)Ĭheck Box - Form Control or ActiveX Control You can always ask an expert in the Excel Tech Community or get support in the Answers community.Excel VBA - ActiveX Controls, Form Controls & AutoShapes on a WorksheetĪctiveX controls, Form controls & AutoShapes in an Excel WorksheetĪdd an ActiveX Control, a Form Control or an AutoShape, in Worksheet When you work with many controls that are positioned close to each other, zoom to a larger size to magnify the view.įor more information, see Zoom in or out of a document, presentation, or worksheet. On the Developer tab, in the Controls group, turn on Design Mode. In the Customize the Ribbon drop-down list, select Main Tabs. If the Developer tab is not available, display it:Ĭlick the File tab, and then click Options. If the shortcut menu contains the command Edit Text, the object is a Drawing Tools object.įor a Form control, click the control and make sure that the control border is displayed. If the shortcut menu contains the command Properties, the control is an ActiveX control, and Excel is in Design mode. Tip: To display the correct shortcut menu for a group box Form control, make sure that you select the perimeter of the group box, and not the interior of the group box. If the shortcut menu contains the command Assign Macro, the control is a Form control. To determine the type of control you are working with, right-click the control, and then note the following: Because there are three different types of controls and objects that you can modify uniquely, you may not know for sure which type of control it is just by looking at it. Many controls are positioned close to each other.įirst, determine the type of control that you want to select. If Excel is not in Design mode, when you try to select an ActiveX control, you might unintentionally start an action, such as running a macro or selecting a check box. Causeīecause a Form control can contain text or other objects (such as an image), when you try to select the control, you might not be selecting the entire control if you do not position the pointer precisely on the control border. Selecting a control is sometimes difficult and unpredictable. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 More.
0 kommentar(er)
