Add or register an ActiveX control Excel 2007

Author: mety Labels::

addition to the various Form controls, your computer contains many ActiveX controls installed by Microsoft Office Excel and other programs, such as Calendar Control 12.0, and Windows Media Player. When you install new ActiveX controls (ActiveX control: A control, such as a check box or button that offers options to users or runs macros or scripts that automate a task. You can write macros for the control in Microsoft Visual Basic for Applications or scripts in Microsoft Script Editor.), the Setup program for the controls usually registers each control on your computer, which makes it available to use from Excel. If the control doesn't appear in the list, you must register it manually.

Important Not all ActiveX controls can be used directly on worksheets; some can be used only on Microsoft Visual Basic for Applications (VBA) (Visual Basic for Applications (VBA): A macro-language version of Microsoft Visual Basic that is used to program Microsoft Windows-based applications and is included with several Microsoft programs.) UserForms. When you work with these controls, Excel displays the message Cannot insert object if you try to add them to a worksheet.

Add an ActiveX control

  1. If the Developer tab is not available, display it.

    HideDisplay the Developer tab

    1. Click the Microsoft Office Button Button image, and then click Excel Options.
    2. In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

      Note The Ribbon is a component of the Microsoft Office Fluent user interface.

  2. On the Developer tab, in the Controls group, click Insert, and then under ActiveX Controls, click More Controls Button image.

    Controls group

  3. In the More Controls dialog box, select a control from the list of available controls on your computer.
  4. Click the worksheet location where you want the upper-left corner of the ActiveX control to appear.
  5. To edit the control, make sure that you are in design mode. On the Developer tab, in the Controls group, turn onDesign Mode Button image .
  6. To specify the control properties, on the Developer tab, in the Controls group, click Properties Edit code button .

    Tip You can also right-click the control, and then click Properties.

    The Properties dialog box appears. For detailed information about each property, select the property, and then press F1 to display a Visual Basic Help (Visual Basic Help: To get Help for Visual Basic, point to Macro on the Tools menu, and then click Visual Basic Editor. On the Help menu, click Microsoft Visual Basic Help.) topic. You can also type the property name in the Visual Basic Help Search box.

Register an ActiveX control

  1. If the Developer tab is not available, display it.

    HideDisplay the Developer tab

    1. Click the Microsoft Office Button Button image, and then click Excel Options.
    2. In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

      Note The Ribbon is a component of the Microsoft Office Fluent user interface.

  2. On the Developer tab, in the Controls group, click Insert, and then under ActiveX Controls, click More Controls Button image.

    Controls group

  3. Click the worksheet location where you want the upper-left corner of the ActiveX control to appear.
  4. To edit the ActiveX control, make sure that you are in design mode. On the Developer tab, in the Controls group, turn on Design Mode Button image.
  5. At the bottom of the More Controls dialog box, click Register Custom.
  6. In the Register Custom Control dialog box, locate the folder that contains the control file (.ocx file name extension) or dynamic link library file (.dll file name extension) for the control that you want to register.
  7. Select the file for your control, and then click Open.

0 comments |

Labels

Blog Archive

Powered by Blogger.

I made these pages for me and my friends to help solving the problem we face regarding Computer & internet, if anyone wants me to answer a question or find out about some information please send me email and I will try to reply.*P.S. some of the article I wrote and the other I found on the internet I posted them in sprit of learning and shearing, please forgive me if you found something you don’t want to be in my blog, email me and I will delete them. Thank you for your interest in my pages.امل نجم Amal Nagm

banner 1 banner 2