当某个单元格数值等于特定值时，就报警响铃，请问怎么实现？

你是那块小饼干

让EXCEL报警，估计还行不通

满坛皆为吾师

你是那块小饼干 发表于 2024-11-1 09:59
让EXCEL报警，估计还行不通

1. Private Declare PtrSafe Sub Beep Lib "kernel32" (ByVal dwFreq As Long, ByVal dwDuration As Long)
   
2. Private Sub Worksheet_Change(ByVal Target As Range)
   
3.     If Target.Address = "$A$1" And [a1] = 666 Then Beep 1000, 1000 '1000赫兹，1秒
   
4. End Sub

复制代码