Editable MSHFlexgrid

        This time we will practice how to control MSHFlexgrid just like excel can be edited, without the help of other components. Whether it can be done by MSHFlexgrid ? The answer is that it can.
          Open a new project in VB6 you, then add the control MSHFlexgrid. On the property form KeyPreview = true property setting. Then in the keypress event of MSHFlexgrid add the following:
 
 
 Private Sub MSHFlexgrid1_KeyPress(KeyAscii As Integer)
 Select Case KeyAscii
           Case vbKeyReturn, vbKeyTab
                   If MSHFlexgrid1.Col + 1 <= MSHFlexgrid1.Cols - 1 Then
                      MSHFlexgrid1.Col = MSHFlexgrid1.Col + 1
                      Else
                      If MSHFlexgrid1.Row + 1 <= MSHFlexgrid1.Rows - 1 Then
                          MSHFlexgrid1.Row = MSHFlexgrid1.Row + 1
                          MSHFlexgrid1.Col = 0
                          Else
                          MSHFlexgrid1.Row = 1
                          MSHFlexgrid1.Col = 0
                      End If
                  End If
            Case vbKeyBack
                   If Len(MSHFlexgrid1.Text) Then
                       .Text = Left(MSHFlexgrid1.Text, Len(MSHFlexgrid1.Text) - 1)
                       End If
           Case Is < 32
           Case Else
                  MSHFlexgrid1.Text = MSHFlexgrid1.Text & Chr(KeyAscii)
 End Select
 End Sub
 
 
          Then run the program via the menu in vb6 you, place the cursor on the control MSHFlexgrid, then do the edit process. If your program is correct then the editing process on the cell in the control MSHFlexgrid will run normally.


More topic of Mshflexgrid
 
 -. How to Use MSHFlexgrid ?
 -. Mshflexgrid with Adodc

 -. Attach textbox to MSHFlexgrid
 -. Select Single Cell in MSHFlexgrid
 -. MSHFlexgrid select a cell and change background

Postingan populer dari blog ini

vb6 msflexgrid

Gambar
         One of the control or component in program Visual Basic 6.0 is vb6 msflexgrid . Function and their role is similar to mshflexgrid . Which displays the data in the form of rows and columns. Or if in the form of web programming output more use html tables. Control is a little different with mshflexgrid.               The use of control is very simple and easy. To add in a form can be added as follows:         Create a new project in Visual Basic 6.0 program, and then add a form. To add a component or control vb6 msflexgrid into a then double click the control that is in the collection box components. If no then you have not added control into the collection box components.         For that you must add it by right-clicking on the area of the component box, then check that in a control called Microsoft Msflexgrid Control 6.0, after checked and then press the OK button aplly or. If there is no problem in your visual basic program, then the control will add a collection of controls
Baca selengkapnya

Tutorial Visual Basic 6.0 : Listbox in VB6

Gambar
In Visual Basic 6.0 Tutorial explained that the property on the ListBox control will determine whether the sign is displayed or not the checkbox next to each item. If the city checkbox is displayed then the ListBox displays the form of multiple choices by checking the checkboxnya. But if not shown, then only one data that can be selected. ListBox in VB6 has its own characteristics, ie when the event raised ItemCheck, propertynya has actually changed. In this control , provides an array of data as a place of shelter data. References it is the index. Array is an array list that starts from zero on the item STRING and what the user saw. ItemData array is an array of LONG INTEGER items where you can place an optional numeric data item associated with the item strings accordingly. If ItemData used, each element is always in touch with the appropriate element from the array list, which means it is not an independent array. You can not control the property Listbox i
Baca selengkapnya

Select Single Cell in MSHFlexgrid

Gambar
         How to use MSHFlexgrid in selecting a particular column. It is very easy, as shown in the picture below. For example a data has been shown in contorl MSHFlexgrid, then the user will select one of the existing data in that column, then the program for manangkap data chosen by the user are as follows:        Private Sub Command1_Click()       MsgBox (MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, MSHFlexGrid1.Col))  End Sub     More topic of Mshflexgrid    -. How to Use MSHFlexgrid ?  -. Mshflexgrid with Adodc  -. Editable MSHFlexgrid  -. Attach textbox to MSHFlexgrid  -. MSHFlexgrid select a cell and change background
Baca selengkapnya