Excel 表中,我在A1、A2…A99录入,同样B1到B99设有vlookup公式,B1对A1

vlookup没有朗读功能，打开VBE，双击sheet1，复制粘贴下面的代码，关闭VBE即可。Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count 1 Then Exit Sub If Target.Column = 1 Then Application.Speech.Speak TargetEnd Sub