Category: Tips

In the previous blog post we described how to add an ActiveX component (control) to a Visual Basic 2010 project. In this blog post we will describe how to insert an ActiveX component in an Excel sheet. We will show the necessary steps to include an ActiveX component in a sheet in Microsoft Excel 2010. We will use the same calendar component as in the previous blog post in this step-by-step example (we will use the one month calendar from SamLogic Calendar Components).

How to add an ActiveX component to an Excel 2010 sheet

1. Start Microsoft Excel 2010.

2. First make sure that the Developer tab is visible in the Ribbon interface. If not, follow the steps (A-E) below:

A. Open the File tab in the Ribbon.
B. Select Options.
C. Choose Customize Ribbon.
D. Check the Developer checkbox.

E. Close the Excel Options dialog box. The Developer tab in the Ribbon interface should now be visible.

3. Open the Developer tab.

4. Click on the Insert Controls option.

5. Click on the More Controls option in the ActiveX Controls group.

6. From the control list in the More Controls dialog box, choose the SamLogic SLXCal Control control and press the OK button.

7. A cross-like cursor will now appear. Click somewhere in the sheet to specify the calendar component’s position in the sheet.

The calendar component should now appear in the sheet as shown in the picture above.

That’s all steps that we need. We have now added an ActiveX component to an Excel sheet!

Events
The calendar component is event driven, so if you want to open up an event handler for the calendar you can double-click on the calendar component. The DateChanged event handler will now be shown in a code window.

If you click on the dropdown list in the upper right of the code editor you can choose another event handler, for example the DateSelected event handler. The DateChanged event is fired when a user changes month in the calendar and the DateSelected event is fired when a user clicks on a date (day number) in the calendar.

Properties
You can set some properties for the calendar component before it is used. If you switch back to the Excel sheet with the calendar and right-click on the calendar and choose the Properties menu item in the local menu that is shown, you will find a list with properties for the calendar component. If you want to set any properties before any code is executed you can set them here.

After the execution of the code has started, you can change properties for the calendar component programmatically.

More information about the one month calendar component
More detailed information about the one month calendar component in SamLogic Calendar Components, including a complete list of all properties, events and methods in the component, is available on this web page:

> One-Month Calendar Component (ActiveX)

In the next blog post
In the next blog post we will show how to install an ActiveX component in a Windows system. Just copying an ActiveX component to a computer’s hard disk is not enough; no, it needs also to be registered in the system. And it is important that the component is installed in the correct folder on the hard disk, otherwise a software using the component may get problem finding the component. In the next blog post we will describe the process of installing an ActiveX component in a Windows system closer.

The components in our toolboxes, for example SamLogic Calendar Components and SamLogic Internet Components, are based on the ActiveX technology. That’s a component technology that was introduced already in 1996 by Microsoft, but it is still supported by many tools, including the latest versions of Microsoft Visual Studio and Microsoft Office.

In this blog post we will show how to add an ActiveX component (control) to a Visual Basic 2010 project by using Microsoft Visual Studio 2010. We will add our one month calendar component from the SamLogic Calendar Components tool box to the Visual Basic project.

If you want to use the calendar component in your own project you must install SamLogic Calendar Components first. But you can also consider this tip as a general step-by-step tip that shows how to insert an ActiveX component into a VB 2010 project. The steps are the same also if you add another ActiveX component to your project.

How to add an ActiveX component to a Visual Basic 2010 project

1. Start Visual Studio 2010 and open a Visual Basic 2010 project, or create a new project. The project type must be Windows Form Application.

2. Right-click over the Toolbox window.

3. Select the Choose items menu item in the local menu that is shown.

4. The Choose Toolbox Items dialog box is now shown. In this dialog box, open the COM Components tab.

5. If you have installed SamLogic Calendar Components and want to use the 1 month calendar, select SamLogic SLXCal Control in the list (in the COM Components tab). Otherwise, select the ActiveX component that you want to use.

6. Click OK to close the dialog box.

7. The selected component should be visible in the Toolbox window; probably in the bottom of the window.

8. Now drag and drop the component on the Windows form, in the position that you want to have the component.

That’s all steps that we need. We have now included an ActiveX component into a Visual Basic 2010 project and put it on a form! You can use the ActiveX component in a similar way as a visual .NET component / .NET class.

The calendar component’s event handlers
If you double-click on the calendar component in the form, the DateChanged event handler is created in the source code (as seen in the picture below):

The DateChanged event occurs when a user changes month in the calendar (for example by clicking on the right arrow). From the event handler dropdown list in Visual Studio’s source code editor you can choose another event handler for the calendar, for example the DateSelected event handler. The DateSelected event occurs when a user selects a date in the calendar by clicking on a date (day number) with the mouse button. There is also a DateDeselected event handler that is fired when somebody unselects a date (removes a selection) in the calendar, for example by clicking with the right mouse button.

More information about the one month calendar component
More detailed information about the one month calendar component in SamLogic Calendar Components, including a complete list of all properties, events and methods in the component, is available on this web page:

> One-Month Calendar Component (ActiveX)

In the next blog post
In the next blog post we will show how to insert an ActiveX component in an Excel sheet. We will use the same calendar component as above in the example, but the tip can also be used for other ActiveX components.

We have created some useful tips pages for the Visual Installer setup tool. You can find an index page with links to the tips on the following page:

> Tips & tricks for SamLogic Visual Installer

We cover topics like self-extracting setup packages, silent installations, update handling, installation of 64-bit programs, shortcuts, Windows Registry, code signing, etc.

If you are using Microsoft Windows 8 on a computer that has no touch screen interface (for example a traditional desktop computer) you may find it hard to access some functions in the operating system. Things will be easier if you are familiar with some of the new keyboard shortcuts that were added to Windows 8. With these keyboard shortcuts you can handle apps, search for files, configure settings etc. more easily.

Article – New Keyboard Shortcuts in Windows 8
In this article on our web site you will find a list of useful keyboard shortcuts in Windows 8, that will help you to manage and master Windows 8 also on devices that have no touch screen interfaces:

> New Keyboard Shortcuts (Hot Keys) in Windows 8