Question

vb里spread控件的问题

vb里窗体显示后，点击按钮后，怎么能把spread的任意一行隐藏？

Answer 1

Private Sub Command1_Click()
Dim xinxi As Integer
xinxi = InputBox("请输入要隐藏的列！", "隐藏列")
If xinxi Like "[0-9]" Then
With Me.fpSpread1
.Row = xinxi
.RowHidden = True
End With
Else
MsgBox "想要隐藏行请输入要隐藏第几行？（合法字符为：数字）"
Exit Sub
End If
End Sub

不知道你是不是要这样的效果，想要重新显示的话，再把RowHidden 设置为False 就可以了。