📄
字号:
Name = "Tahoma"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 330
Left = -74040
Style = 2 'Dropdown List
TabIndex = 23
Top = 600
Width = 3495
End
Begin VB.Frame Frame3
Caption = "正文显示"
Height = 1575
Left = 150
TabIndex = 19
Top = 1740
Width = 2175
Begin VB.OptionButton Option7
Caption = "单行显示"
Height = 255
Left = 300
TabIndex = 22
Top = 300
Value = -1 'True
Width = 1575
End
Begin VB.OptionButton Option8
Caption = "自动折行显示"
Height = 255
Left = 300
TabIndex = 21
Top = 630
Width = 1575
End
Begin VB.OptionButton Option9
Caption = "显示覆盖信息..."
Height = 255
Left = 300
TabIndex = 20
Top = 960
Width = 1695
End
End
Begin VB.Frame Frame8
Caption = "对齐"
Height = 1035
Left = 150
TabIndex = 8
Top = 510
Width = 4635
Begin VB.Frame Frame2
BorderStyle = 0 'None
Height = 255
Left = 1320
TabIndex = 13
Top = 240
Width = 2775
Begin VB.OptionButton Option3
Caption = "居右"
Height = 255
Left = 2130
TabIndex = 16
Top = 30
Width = 975
End
Begin VB.OptionButton Option2
Caption = "居中"
Height = 255
Left = 1140
TabIndex = 15
Top = 30
Width = 975
End
Begin VB.OptionButton Option1
Caption = "居左"
Height = 255
Left = 90
TabIndex = 14
Top = 30
Value = -1 'True
Width = 975
End
End
Begin VB.Frame Frame1
BorderStyle = 0 'None
Height = 255
Left = 1320
TabIndex = 9
Top = 600
Width = 2775
Begin VB.OptionButton Option6
Caption = "居下"
Height = 255
Left = 2130
TabIndex = 12
Top = 60
Value = -1 'True
Width = 975
End
Begin VB.OptionButton Option5
Caption = "居中"
Height = 255
Left = 1140
TabIndex = 11
Top = 60
Width = 855
End
Begin VB.OptionButton Option4
Caption = "居上"
Height = 210
Left = 90
TabIndex = 10
Top = 60
Width = 735
End
End
Begin VB.Label Label1
Caption = "水平居中:"
Height = 255
Left = 300
TabIndex = 18
Top = 270
Width = 1095
End
Begin VB.Label Label2
Caption = "垂直居中:"
Height = 255
Left = 300
TabIndex = 17
Top = 630
Width = 975
End
End
Begin VB.Frame Frame4
Caption = "文本方向"
Height = 1575
Left = 2520
TabIndex = 4
Top = 1740
Width = 2235
Begin VB.OptionButton Option10
Caption = "水平"
Height = 255
Left = 300
TabIndex = 7
Top = 300
Width = 1575
End
Begin VB.OptionButton Option11
Caption = "垂直向下"
Height = 255
Left = 300
TabIndex = 6
Top = 630
Width = 1335
End
Begin VB.OptionButton Option12
Caption = "垂直向上"
Height = 255
Left = 300
TabIndex = 5
Top = 960
Width = 1455
End
End
Begin MSComctlLib.ImageCombo ImageCombo1
Height = 345
Left = -74040
TabIndex = 26
Top = 1560
Width = 1215
_ExtentX = 2143
_ExtentY = 609
_Version = 393216
ForeColor = -2147483640
BackColor = -2147483643
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "Tahoma"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Locked = -1 'True
Text = "ImageCombo1"
ImageList = "ImageList1"
End
Begin VB.Label Label10
Caption = "小数位数:"
Height = 225
Left = -74640
TabIndex = 39
Top = 2040
Width = 1095
End
Begin VB.Label Label9
Caption = "货币符号:"
Height = 225
Left = -74640
TabIndex = 38
Top = 1590
Width = 1095
End
Begin VB.Label Label8
Caption = "千分位:"
Height = 255
Left = -74640
TabIndex = 37
Top = 1140
Width = 1095
End
Begin VB.Label Label7
Caption = "颜色:"
Height = 375
Left = -74640
TabIndex = 30
Top = 1620
Width = 615
End
Begin VB.Label Label6
Caption = "字号:"
Height = 375
Left = -74640
TabIndex = 29
Top = 1170
Width = 615
End
Begin VB.Label Label5
Caption = "字型:"
Height = 375
Left = -72480
TabIndex = 28
Top = 1170
Width = 615
End
Begin VB.Label Label4
Caption = "字体:"
Height = 375
Left = -74640
TabIndex = 27
Top = 720
Width = 615
End
End
Begin VB.CommandButton Command2
Cancel = -1 'True
Caption = "取消(&C)"
Height = 300
Left = 3870
TabIndex = 1
Top = 3630
Width = 1120
End
Begin VB.CommandButton command1
Caption = "确认(&O)"
Default = -1 'True
Height = 300
Left = 2640
TabIndex = 0
Top = 3630
Width = 1120
End
Begin VB.TextBox Text2
Height = 270
Left = 1800
TabIndex = 2
Text = "Text2"
Top = 360
Width = 255
End
End
Attribute VB_Name = "frm_cell"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'***********************************************
'* 模 块 名 称 :单元格属性
'* 功 能 描 述 :
'* 程序员姓名 :奚俊峰
'* 最后修改人 :奚俊峰
'* 最后修改时间:2002/01/21
'***********************************************
Option Explicit
Private Sub mf_init_color(ByVal limgcmb_1 As ImageCombo) '颜色
limgcmb_1.ComboItems.Add 1, "p1", "", 1
limgcmb_1.ComboItems.Add 2, "p2", "", 2
limgcmb_1.ComboItems.Add 3, "p3", "", 3
limgcmb_1.ComboItems.Add 4, "p4", "", 4
limgcmb_1.ComboItems.Add 5, "p5", "", 5
limgcmb_1.ComboItems.Add 6, "p6", "", 6
limgcmb_1.ComboItems.Add 7, "p7", "", 7
limgcmb_1.ComboItems.Add 8, "p8", "", 8
limgcmb_1.ComboItems.Add 9, "p9", "", 9
limgcmb_1.ComboItems.Add 10, "p10", "", 10
limgcmb_1.ComboItems.Add 11, "p11", "", 11
limgcmb_1.ComboItems.Add 12, "p12", "", 12
limgcmb_1.ComboItems.Add 13, "p13", "", 13
limgcmb_1.ComboItems.Add 14, "p14", "", 14
limgcmb_1.ComboItems.Add 15, "p15", "", 15
limgcmb_1.ComboItems.Add 16, "p16", "", 16
limgcmb_1.ComboItems.Add 17, "p17", "", 17
limgcmb_1.ComboItems.Add 18, "p18", "", 18
limgcmb_1.ComboItems.Add 19, "p19", "", 19
limgcmb_1.ComboItems.Add 20, "p20", "", 20
limgcmb_1.ComboItems.Add 21, "p21", "", 21
limgcmb_1.ComboItems.Add 22, "p22", "", 22
limgcmb_1.ComboItems.Add 23, "p23", "", 23
limgcmb_1.ComboItems.Add 24, "p24", "", 24
limgcmb_1.ComboItems.Add 25, "p25", "", 25
limgcmb_1.ComboItems.Add 26, "p26", "", 26
limgcmb_1.ComboItems.Add 27, "p27", "", 27
End Sub
Private Sub mf_init_combo2()
Dim i As Long
For i = 0 To Screen.FontCount
If Len(Trim(Screen.Fonts(i))) > 0 Then
Combo2.AddItem Screen.Fonts(i)
End If
Next i
End Sub
Private Sub Command1_Click()
Dim i As Long, j As Long, ll_alignment As Long, ll_forecolor_old
Dim ll_textstyle As Long, ll_fontsize As Long, ll_fontstyle As Long
Dim ls_fontname As String, ll_forecolor As Long, ll_backcolor
Dim ll_qfw As Long, ll_bfs As Long, ll_xsws As Long, ll_hbfh As Long
Dim ll_unit As Long, ll_fs As Long, ll_kxjs As Long, ls_note As String
Dim ls_read As Boolean, ls_hide As Boolean
Dim ls_zhdx1 As Boolean, ls_zhdx2 As Boolean, ls_zhdx3 As Boolean
Dim ll_orientation As Long, ll_zero As Long
Dim ll_col_begin, ll_row_begin, ll_col_end, ll_row_end
ll_alignment = 0
With MDI_frame.ActiveForm
'设置单元格对齐
If Option1.Value = True Then
ll_alignment = ll_alignment + 1
End If
If Option2.Value = True Then
ll_alignment = ll_alignment + 4
End If
If Option3.Value = True Then
ll_alignment = ll_alignment + 2
End If
If Option4.Value = True Then
ll_alignment = ll_alignment + 8
End If
If Option5.Value = True Then
ll_alignment = ll_alignment + 32
End If
If Option6.Value = True Then
ll_alignment = ll_alignment + 16
End If
'设置折行
If Option7.Value = True Then
ll_textstyle = 0
End If
If Option8.Value = True Then
ll_textstyle = 1
End If
If Option9.Value = True Then
ll_textstyle = 2
End If
If Option10.Value = True Then
ll_orientation = 0
End If
If Option11.Value = True Then
ll_orientation = -90
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -