Adam has attended:
Excel Advanced course
Excel spreadsheet makes sound when a1>b2
excel spreadsheet makes sound every 0.5 seconds when a1>b2
RE: 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
RE: 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
RE: 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
RE: 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
