Category Archive for: More Advanced ActiveX Controls

Using a Class Module

Let’s implement the same project, but this time with a Class Module. The Class Module will completely hide the implementation details. It will expose its functionality and the developer will never see or edit its source code. Save the existing project and then start a new project (it’s the c timer project in this chapter’S folder on the…

Read More →

Data Entry

The MSFlexGrld control is an extremely useful tool for displaying data, but it lacks it basic capability: the user cannot edit a single cell. This limitation can be easily overcome with the help 0.,£ an edit control, namely, the TextBox control. The grid itself provides a few properties and events that make the task of combining the MSFlex-Grid…

Read More →

Merging Cells

Another useful operation you may want to perform on a grid’s data is to merge cells with identical data. Figure 9.16 A shows a grid with duplicate data, and Figure 9.16 B shows the same grid after certain cells were merged. The MSFlexGrid control provides a mechanism for merging adjacent cells automatically if their contents happen to…

Read More →

Displaying Rows and Columns

In Figure 9.9, the cells of the first row and column have a gray background because they are meant to be used as titles for the corresponding columns and rows. The unique feature of these cells is that they don’t scroll along with the rest of the cells, so the titles always remain visible. You can change the…

Read More →

The MSFlexGrid Control

One of the most impressive controls of Visual Basic is the MSFlexGrid control. As you can guess by its name, the MSFlexGrid control is a descendant of theold Grid control. The MSFlexGrid control provides all the functionality for building spreadsheet applications, just as the RichTextBox control provides all the functionality for building word processing applications. Once you master its…

Read More →

The RichTextBox Control’s Methods

The first two methods of the RichTextBox control you will learn about are Save File and LoadFile: SaveFile saves the contents of the control to a disk flle. LoadFile loads the control from a disk file. The syntax of the SaveFile method is as follows: RichTextBox1.SaveFile(filename, filetype) The filename argument is the full path name…

Read More →

More Advanced ActiveX Controls

This chapter explores a few of the more advanced ActiveX controls that you’ll find useful in building elaborate applications such as word processors and spreadsheets, and they are: The RichTextBox control, the core of a word processor, wrapped as an ActiveX control The MSFlexGrid control, the core of a spreadsheet application, also wrapped as an ActiveX control The RichTextBoxcontrol…

Read More →

Back to Top