vba雙擊單元格可以彈出視窗?mliho9392019-11-05 15:37:19

請用工作表的BeforeDoubleClick事件:12345Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target。Address = Range(“A1”

) Then userfomr1。Show End IfEnd Sub