form controls vs activex controls in excel

Windows Forms controls generally have the same behavior on documents as on these other UI elements, but some differences do exist. You can add Windows Forms controls to documents and to customizable user interface (UI) elements, including actions panes, custom task panes, and Windows Forms. For more information, see Features available by Office application and project type. You can programmatically add these controls to any open document or worksheet at run time in a VSTO Add-in for Excel or Word.įor more information, see How to: Add Windows Forms controls to Office documents.Īpplies to: The information in this topic applies to document-level projects and VSTO Add-in projects for Excel and Word. In document-level projects for Microsoft Office Excel and Microsoft Office Word, you can add Windows Forms controls to the document or workbook in your project at design time, or you can programmatically add these controls at run time.

If you do not wish to work with a macro then you can add the button to the quick access toolbar (QAT).Windows Forms controls are objects that users can interact with to enter or manipulate data. What if we use a shape like an oval and assign it to a macro? The VBA code below will ensure that the shape stays in its fixed position: Of course, we have to change the name of the controls according to our assignments. With ActiveSheet.OLEObjects(“CommandButton1”) What if we use an ActiveX control? The following macro will solve the problem:

Private Sub Worksheet_SelectionChange(ByVal Target As Range) Below is the code to keep the form control buttons in place: Therefore, we need to write a macro or VBA code to ensure that the controls remain in a fixed position or stay put. But many a times this does not work and the controls become larger or smaller. How can we ensure that our shapes and controls on the worksheet remain in a fixed position where we wish to have them? We can do this manually by right-clicking on the shapes or controls and selecting ‘Don’t move or size with cells’. However, we also notice that the controls shift their positions or disappear entirely when we execute a macro assigned to these controls. This makes it easier for us to run a macro by clicking on the shape, ActiveX control like a command button or form control button. Often we insert shapes, ActiveX controls and form controls on our worksheet and assign a macro to them. Fix Position of Form Control Button on Worksheet automatically with VBA

Form controls vs activex controls in excel