📄 cellform.frm

📁 证券公司监测内部客户资金流向的系统
💻 FRM
📖 第 1 页 / 共 4 页
字号:
上一页 1 2 34
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   255
         Left            =   0
         TabIndex        =   10
         Top             =   240
         Value           =   1  'Checked
         Width           =   2655
      End
      Begin VB.Label Label1 
         Caption         =   "CELL比任何其他表格具有更丰富的Sizing操作，无论是行标，列标，行高，列宽，单元格大小，均是可调整大小的，当然，也可以禁止。"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   9
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   735
         Left            =   0
         TabIndex        =   12
         Top             =   720
         Width           =   6975
      End
   End
   Begin VB.PictureBox picPicture 
      BorderStyle     =   0  'None
      Height          =   1575
      Index           =   0
      Left            =   120
      ScaleHeight     =   1575
      ScaleWidth      =   7215
      TabIndex        =   1
      Top             =   3600
      Width           =   7215
      Begin VB.CheckBox chkPage 
         Caption         =   "页签"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   9
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   2880
         TabIndex        =   8
         Top             =   720
         Value           =   1  'Checked
         Width           =   735
      End
      Begin VB.CheckBox chkBorder 
         Caption         =   "边框"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   9
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   2880
         TabIndex        =   7
         Top             =   240
         Value           =   1  'Checked
         Width           =   855
      End
      Begin VB.CheckBox chkV 
         Caption         =   "垂直滚动条"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   9
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   1200
         TabIndex        =   6
         Top             =   720
         Value           =   1  'Checked
         Width           =   1455
      End
      Begin VB.CheckBox chkH 
         Caption         =   "水平滚动条"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   9
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   1200
         TabIndex        =   5
         Top             =   240
         Value           =   1  'Checked
         Width           =   1455
      End
      Begin VB.CheckBox chkRow 
         Caption         =   "列标"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   9
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   120
         TabIndex        =   4
         Top             =   720
         Value           =   1  'Checked
         Width           =   855
      End
      Begin VB.CheckBox chkCol 
         Caption         =   "行标"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   9
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   120
         TabIndex        =   3
         Top             =   240
         Value           =   1  'Checked
         Width           =   1095
      End
   End
   Begin VB.CommandButton CBFinished 
      Cancel          =   -1  'True
      Caption         =   "关闭"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   6360
      TabIndex        =   0
      Top             =   5400
      Width           =   1095
   End
End
Attribute VB_Name = "frmCell"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Private Sub CBFinished_Click()
    Unload Me
End Sub

Private Sub Check1_Click()
DemoCell.DynamicEditArea = Check1.Value
End Sub

Private Sub chkAdjust_Click()
DemoCell.AllowSizeCell = chkAdjust.Value
End Sub

Private Sub chkBorder_Click()
DemoCell.Border = chkBorder.Value
End Sub

Private Sub chkCol_Click()
DemoCell.SideLabelVisible = chkCol.Value
End Sub

Private Sub chkH_Click()
DemoCell.HScrollVisible = chkH.Value
End Sub

Private Sub chkPage_Click()
DemoCell.PageLabelVisible = chkPage.Value
End Sub

Private Sub chkRetract_Click()
DemoCell.MultiColSizeMode = chkRetract.Value
End Sub

Private Sub chkRow_Click()
DemoCell.TopLabelVisible = chkRow.Value
End Sub

Private Sub chkV_Click()
DemoCell.VScrollVisible = chkV.Value
End Sub

Private Sub cmdCopy_Click()
DemoCell.DoCopySelected
End Sub

Private Sub cmdCut_Click()
DemoCell.DoCutSelected
End Sub

Private Sub cmdPaste_Click()
DemoCell.DoPaste DemoCell.DoGetCurrentCol, DemoCell.DoGetCurrentRow, False
End Sub

Private Sub cmdPasteSize_Click()
DemoCell.DoPaste DemoCell.DoGetCurrentCol, DemoCell.DoGetCurrentRow, True
End Sub

Private Sub Command1_Click()
If Len(Text1) > 0 Then
End If
End Sub

Private Sub Command10_Click()
frmCell.DemoCell.DoOpenFile Text6
End Sub

Private Sub Command11_Click()
frmCell.DemoCell.DoSaveFile Text6
End Sub

Private Sub Command2_Click()
MsgBox "CELL中的表达式有四种数据类型∶数值，字串，单元，区域。可以在表达式中使用一些常用的函数(在输入公司对话框中有详细说明。对数值类型来说，可进行四则运算及逻辑运算；对字串类型，可进行比较及加法运算；单元类型可参加数值及字串的运算，只要参加任何运算，表达式的类型就转化为数值或者字串(不再是单元类型)；对区域类型来说，不能参加任何运算(参加了就是错)。" & vbCrLf & "那区域类型有什么用呢?你一定会问。有用的，当你指定自定义函数参数的时候有用。"
End Sub

Private Sub Command3_Click()
frmCell.DemoCell.DoPrint True
End Sub

Private Sub Command4_Click()
frmCell.DemoCell.DoPrintPreview False
End Sub

Private Sub Command5_Click()
With DemoCell
  ipage = Val(Text3)
  If ipage < .DoGetTotalPages Then
      .DoSetCurrentPage ipage - 1
      .DoRedrawPageLabel
  End If
End With
End Sub

Private Sub Command6_Click()
With DemoCell
  .DoSetPageLabel .DoGetCurrentPage, Text4
  .DoRedrawPageLabel
End With
End Sub

Private Sub Command7_Click()
With CommonDialog
  .Filter = "Access 文件(*.MDB)|*.mdb"
  .ShowOpen
  Text5 = .FileName
End With
End Sub

Private Sub Command8_Click()
Dim sTableName As String
Dim iInstr
With frmCell.DemoCell
  .DoOpenFileDbase 0, Text5, sTables
  If Len(sTables) > 0 Then
    For i = 0 To 2
      iInstr = InStr(sTables, vbCrLf)
      If iInstr > 0 Then
        sTableName = Left(sTables, iInstr - 1)
        sTables = Right(sTables, Len(sTables) - iInstr - 1)
        If i > 0 Then .DoAppendPage "", 1
        .DoDumpDbaseTable sTableName, 0, -1, i, True, varcols, varrows
      End If
    Next
  End If
  .DoCloseDbase
End With
End Sub

Private Sub Command9_Click()
With CommonDialog
  .Filter = "Cell 表文件(*.CLL)|*.cll"
  .ShowOpen
  Text6 = .FileName
End With
End Sub

Private Sub DemoCell_OnExecuteUserFunc(ByVal name As String, ByVal rettype As Integer, ByVal paranum As Integer, paraType As Long, funcResult As Variant)
'one area parameter will output 4 para varibles
    ReDim paraVar((paranum - 1) * 4) As Variant
    ReDim paraVarType((paranum - 1) * 4)
    
    For i = 0 To paranum - 1
        If Not DemoCell.DoFetchFuncParameter(i, paraVar(i)) Then
            Exit Sub
        End If
        paraVarType(i) = VarType(paraVar(i))
    Next
    
    Select Case name
        Case "MyFunction1"
            funcResult = paraVar(0)
            If (rettype = 1) Then
                funcResult = Str(funcResult)
            End If
            If VarType(paraVar(3)) = 0 Then
                MsgBox "The 3rd parameter is default!"
            End If
        Case Else
            MsgBox "No Such User Function"
    End Select
End Sub


Private Sub DemoCell_OnGetCellData(ByVal col As Long, ByVal row As Long, data As Variant, changed As Boolean)
If iSelection = 9 Then
  Dim tmp As Long
  changed = True
  tmp = col + 1 + (row + 1) * 10000
  data = tmp
End If
End Sub

Private Sub optGrid_Click(Index As Integer)
DemoCell.DoSetBackGround Index
End Sub
上一页 1 2 34
💿 文件大小 172 K
👤 上传用户 jxsflq
📂 所属分类金融证券系统
🏷️ 相关标签

#监测
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -