VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Begin VB.Form Form1 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "如何在 MSFlexGrid 中輸入資料"
   ClientHeight    =   4425
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   7500
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   ScaleHeight     =   4425
   ScaleWidth      =   7500
   StartUpPosition =   1  '所有者中心
   Begin VB.CommandButton Command1 
      Caption         =   "退出"
      Height          =   375
      Left            =   5700
      TabIndex        =   2
      Top             =   3990
      Width           =   1515
   End
   Begin VB.TextBox Text1 
      BackColor       =   &H00FF8080&
      BorderStyle     =   0  'None
      Height          =   300
      Left            =   1230
      TabIndex        =   0
      Top             =   645
      Visible         =   0   'False
      Width           =   2055
   End
   Begin MSFlexGridLib.MSFlexGrid MSFlexGrid1 
      Height          =   3510
      Left            =   315
      TabIndex        =   1
      Top             =   330
      Width           =   6855
      _ExtentX        =   12091
      _ExtentY        =   6191
      _Version        =   393216
      Rows            =   1
      AllowBigSelection=   0   'False
      HighLight       =   0
      BorderStyle     =   0
   End
End
Attribute VB_Name = "Form1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Form_Activate()
  Dim i As Integer
  MSFlexGrid1.Rows = 13
  MSFlexGrid1.Cols = 6
  MSFlexGrid1.ColWidth(0) = 12 * 25 * 1
  MSFlexGrid1.ColWidth(1) = 12 * 25 * 3
  MSFlexGrid1.ColWidth(2) = 12 * 25 * 6
  MSFlexGrid1.ColWidth(3) = 12 * 25 * 3
  MSFlexGrid1.ColWidth(4) = 12 * 25 * 4
  MSFlexGrid1.ColWidth(5) = 12 * 25 * 4
  MSFlexGrid1.FixedRows = 1
  MSFlexGrid1.FixedCols = 1
  MSFlexGrid1.TextMatrix(0, 0) = "xh"
  MSFlexGrid1.TextMatrix(0, 1) = " 批號"
  MSFlexGrid1.TextMatrix(0, 2) = " 商品名稱"
  MSFlexGrid1.TextMatrix(0, 3) = " 規(guī)格"
  MSFlexGrid1.TextMatrix(0, 4) = " 廠家/產(chǎn)地"
  MSFlexGrid1.TextMatrix(0, 5) = " 單位"
  For i = 1 To 12
      MSFlexGrid1.TextMatrix(i, 0) = i
  Next i
  Text1.Visible = True
  Text1.Left = MSFlexGrid1.Left + MSFlexGrid1.ColPos(MSFlexGrid1.Col)
  Text1.Top = MSFlexGrid1.Top + MSFlexGrid1.RowPos(MSFlexGrid1.Row)
  Text1.Width = MSFlexGrid1.ColWidth(MSFlexGrid1.Col)
  Text1.Height = MSFlexGrid1.RowHeight(MSFlexGrid1.Row)
  Text1.SetFocus
End Sub
Private Sub MSFlexGrid1_Click()
  If MSFlexGrid1.Col <= 5 And MSFlexGrid1.Row <= 12 Then
     Text1.Left = MSFlexGrid1.Left + MSFlexGrid1.ColPos(MSFlexGrid1.Col)
     Text1.Top = MSFlexGrid1.Top + MSFlexGrid1.RowPos(MSFlexGrid1.Row)
     Text1.Width = MSFlexGrid1.ColWidth(MSFlexGrid1.Col)
     Text1.Height = MSFlexGrid1.RowHeight(MSFlexGrid1.Row)
     Text1 = MSFlexGrid1.Text
     Text1.Visible = True
     Text1.SetFocus
   End If
End Sub
Private Sub MSFlexGrid1_KeyPress(KeyAscii As Integer)
  If KeyAscii = vbKeyReturn Then
     If MSFlexGrid1.Col <= 5 And MSFlexGrid1.Row <= 12 Then
        Text1.Left = MSFlexGrid1.Left + MSFlexGrid1.ColPos(MSFlexGrid1.Col)
        Text1.Top = MSFlexGrid1.Top + MSFlexGrid1.RowPos(MSFlexGrid1.Row)
        Text1.Width = MSFlexGrid1.ColWidth(MSFlexGrid1.Col)
        Text1.Height = MSFlexGrid1.RowHeight(MSFlexGrid1.Row)
        Text1 = MSFlexGrid1.Text
        Text1.Visible = True
        Text1.SetFocus
     End If
  End If
End Sub
Private Sub Text1_KeyPress(KeyAscii As Integer)
  If KeyAscii = vbKeyEscape Then
     Text1.Visible = False
     MSFlexGrid1.SetFocus
     Exit Sub
  End If
  If KeyAscii = vbKeyReturn Then
     MSFlexGrid1.Text = Text1.Text
     If MSFlexGrid1.Col < 5 Then
        MSFlexGrid1.Col = MSFlexGrid1.Col + 1
     Else
       MSFlexGrid1.Row = MSFlexGrid1.Row + 1
       MSFlexGrid1.Col = 1
     End If
     Text1.Left = MSFlexGrid1.Left + MSFlexGrid1.ColPos(MSFlexGrid1.Col)
     Text1.Top = MSFlexGrid1.Top + MSFlexGrid1.RowPos(MSFlexGrid1.Row)
     Text1.Width = MSFlexGrid1.ColWidth(MSFlexGrid1.Col)
     Text1.Height = MSFlexGrid1.RowHeight(MSFlexGrid1.Row)
     Text1 = MSFlexGrid1.Text
     Text1.SetFocus
  End If
End Sub
Private Sub Command1_Click()
  End
End Sub