1,216
社区成员
发帖
与我相关
我的任务
分享
Grid1.Cols = 7
Grid1.AllowUserResizing = False
Grid1.BoldFixedCell = False
Grid1.DisplayFocusRect = False
Grid1.ExtendLastCol = True
Grid1.DrawMode = cellOwnerDraw '允许OwnerDraw,在固定行上画小图标
Grid1.Appearance = Flat
Grid1.FixedRowColStyle = Flat
Grid1.ScrollBarStyle = Flat
Grid1.DefaultFont.Name = "Tahoma"
Grid1.DefaultFont.Size = 8
Grid1.BackColorFixed = RGB(90, 158, 214)
Grid1.BackColorFixedSel = RGB(110, 180, 230)
Grid1.BackColorBkg = RGB(90, 158, 214)
Grid1.BackColorScrollBar = RGB(231, 235, 247)
Grid1.BackColor1 = RGB(231, 235, 247)
Grid1.BackColor2 = RGB(239, 243, 255)
Grid1.GridColor = RGB(148, 190, 231)
Grid1.Cell(0, 1).Text = "TextBox"
Grid1.Cell(0, 2).Text = "ComboBox"
Grid1.Cell(0, 3).Text = "CheckBox"
Grid1.Cell(0, 4).Text = "Calendar"
Grid1.Cell(0, 5).Text = "Button"
Grid1.Cell(0, 6).Text = "HyperLink"
Grid1.Column(1).CellType = cellTextBox
Grid1.Column(2).CellType = cellComboBox
Grid1.Column(2).MaxLength = 4
Grid1.Column(3).CellType = cellCheckBox
Grid1.Column(4).CellType = cellCalendar
Grid1.Column(5).CellType = cellButton
Grid1.Column(6).CellType = cellHyperLink
Grid1.Range(1, 6, Grid1.Rows - 1, 6).ForeColor = vbBlue
Grid1.Column(0).Width = 0
Grid1.Column(1).Width = 100
Grid1.Column(2).Width = 100
Grid1.Column(3).Width = 70
Grid1.Column(4).Width = 100
Grid1.Column(5).Width = 85
Grid1.Column(6).Width = 150
With Grid1.ComboBox(2)
'.Locked = True
'用一种固定宽度的字体,可以使下拉列表中的项目对齐。
.Font.Name = "Courier New"
'第二列最多只能输入4个字符(MaxLength属性),所以后面的数字部分不会显示到单元格。
'如果要让下拉框看起来象一个表格,可以用制表符"│"替换掉"-",用这种方法可以实现多列的下拉框
.AddItem "AAAA - 001"
.AddItem "AAAB - 002"
.AddItem "ABCC - 003"
.AddItem "ABCD - 004"
.AddItem "BAAA - 005"
.AddItem "BBCC - 006"
.AddItem "CABC - 007"
.AddItem "CABB - 008"
.AddItem "CBAA - 009"
.AddItem "DABC - 010"
End With