用这语句:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count = 1 And Target.Column = 1 Then
With TextBox1
.Left = Target.Left
.Top = Target.Top + 1
.Width = Target.Width
.Height = Target.Height - 1
.Visible = True
.Text = ""
.Activate
End With
End If
End Sub
根据情况调整红色数据