98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel spreadsheet makes sound when a1>b2
Excel spreadsheet makes sound when a1>b2
Resolved · Low Priority · Version 365
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Shortcut fill a cell with contents from adjacent cellsUse Control + D to fill a cell with the data from an adjacent cell. This speeds up data entry and is a cool tip to share! |