How to Use OCX & ActiveX in
Visual Basic for Excel 97

wpe21.jpg (7475 bytes)

vba.gif (251 bytes)

 gball.gif (956 bytes) Start your Excel 97 and load a document or create a new document
  1. Choose menu Tools|Macro|Visual Basic Editor or press ALT-F11.
  2. The Microsoft Visual Basic for Application design interface appears.
  3. Choose a existing Form or create a new form. Choose menu Tools|Additional Controls... or right-click the Toolbox and choose Additional Controls... from the popup menu.
  4. Find which control you want to use in your project from the Available Controls list.
  5. Set the check box before the controls you want then click OK in the Additional Controls dialog.
  6. The icons of the controls you choose are showed on the Toolbox. Click the icon to choose a control and put the control onto the form.

gball.gif (956 bytes) I am using Microsoft Excel 97 Professional Edition, Service Release 1, Copyright© 1985, 1997 Microsoft Corporation.

 

Related topics: How to use ActiveX in Microsoft Office 97 Products How to use ActiveX in Word 97 Document (.Doc) How to use ActiveX in Visual Basic for Word 97 How to use ActiveX in Excel 97 Workbook (.xls) How to use ActiveX in PowerPoint 97 Presentation (.Ppt) How to use ActiveX in Visual Basic for PowerPoint 97 How to use ActiveX in Acess 97 How to use ActiveX in Outlook 97 Form Template (.Oft)

Other topics: How to use ActiveX in Products of Inprise Corproation How to use ActiveX in Microsoft Visual Studio Products How to use ActiveX in Microsoft Office 97 Products How to use ActiveX in Internet

Home Page jinhui@jcomsoft.com

 

Your comments and any suggestion are welcomed.
You can send me E-mail or sign my guest book.