excel spreadsheet makes sound

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum 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

resolvedResolved · 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


 

Excel tip:

Shortcut fill a cell with contents from adjacent cells

Use 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!


View all Excel hints and tips


Server loaded in 0.06 secs.