excel中如何用鼠标点击该单元格就显示隐藏表格中内容?

2025-02-23 01:54:06
推荐回答(1个)
回答1:

可以 用 VBA Selecte change 事件
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Set isect = Application.Intersect(Target, Range("B7:G10"))
If Not (isect Is Nothing) Then [g5] = Target
End Sub