Excel spreadsheet makes sound when a1>b2

Hi Adam,
Thank you for the forum question.

Please watch video below.

If you want it to beep every 5 seconds you will need to to learn about VBA events. You will need to learn how to create on change events and on time events.

Sub TimeSayBeep()
Application.Ontime Now+Timevalue("00:L00:05"), "SayBeep"
Call TimeSayBeep
End Sub

will execute a macro called SayBeep every 5 seconds.







https://www.youtube.com/watch?v=ue9a71AEVm4



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Hi Adam,
Thank you for the forum question.

Please watch video below.

If you want it to beep every 5 seconds you will need to to learn about VBA events. You will need to learn how to create on change events and on time events.

Sub TimeSayBeep()
Application.Ontime Now+Timevalue("00:L00:05"), "SayBeep"
Call TimeSayBeep
End Sub

will execute a macro called SayBeep every 5 seconds.







https://www.youtube.com/watch?v=ue9a71AEVm4



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Hi Adam,
Thank you for the forum question.

Please watch video below.

If you want it to beep every 5 seconds you will need to to learn about VBA events. You will need to learn how to create on change events and on time events.

Sub TimeSayBeep()
Application.Ontime Now+Timevalue("00:L00:05"), "SayBeep"
Call TimeSayBeep
End Sub

will execute a macro called SayBeep every 5 seconds.







https://www.youtube.com/watch?v=ue9a71AEVm4



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Hi Adam,
Thank you for the forum question.

Please watch video below.

If you want it to beep every 5 seconds you will need to to learn about VBA events. You will need to learn how to create on change events and on time events.

Sub TimeSayBeep()
Application.Ontime Now+Timevalue("00:L00:05"), "SayBeep"
Call TimeSayBeep
End Sub

will execute a macro called SayBeep every 5 seconds.







https://www.youtube.com/watch?v=ue9a71AEVm4



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector