Private Sub Form_Load()
Combo1.Visible = False
With MSFlexGrid1
.Rows = 20
.Cols = 5
For i = 0 To 4
.TextMatrix(0, i) = "第" & i & "列"
Next
.Font.Size = 15
End With
For i = 0 To 10
Combo1.AddItem Chr(i + 65)
Next
Combo1.Text = ""
End Sub
Private Sub MSFlexGrid1_Click()
Dim myrow As Long, mycol As Long
With MSFlexGrid1
Combo1.FontSize = .Font.Size - 2
myrow = .MouseRow
mycol = .MouseCol
If mycol = 2 Then ' only show combobox in colum 3
Combo1.Move .Left + .ColPos(mycol) + 40, .Top + .RowPos(myrow) + 40, .ColWidth(mycol)
Combo1.Visible = True
End If
End With
End Sub
Private Sub MSFlexGrid1_LeaveCell()
MSFlexGrid1.Text = Combo1.Text
End Sub