Column Beep

[joelmidiowa]

I have an excel sheet that i need to have column A and K beep when i type in an account number. I need beep to go all the way down both column A and K. not at the same time just when an account number is typed in

 

[JoeMo]

This is sheet code for the sheet of interest. Assumes typed entries to both columns A and K will always be account numbers.

Private Sub Worksheet_Change(ByVal Target As Range)
Set Target = Target(1)
If Not Intersect(Target, Range("A:A")) Is Nothing Then
    If Not IsEmpty(Target) Then Beep
End If
If Not Intersect(Target, Range("K:K")) Is Nothing Then
    If Not IsEmpty(Target) Then Beep
End If
End Sub

 

[joelmidiowa]

I copied and pasted your code into the vba module, but when I type in an account number into column A or K it does not beep

 

[JoeMo]

The code doesn't go into a standard module. It's sheet code. remove the code you pasted, then follow the instructions below:

To install sheet code:
1. Right-click the worksheet tab you want to apply it to and choose 'View Code'. This will open the VBE window.
2. Copy the code below from your browser window and paste it into the white space in the VBE window.
3. Close the VBE window and Save the workbook. If you are using Excel 2007 or a later version do a SaveAs and save it as a macro-enabled workbook (.xlsm file extension).
4. Make sure you have enabled macros whenever you open the file or the code will not run.

 

[joelmidiowa]

That worked great. Thank you for your help!

 

[JoeMo]

That worked great. Thank you for your help!

You are welcome - thanks for the reply.

 

[joelmidiowa]

So I am trying to use this same code through the online excel app on OneDrive. Should this code also work on the web version also, do you know by chance?

 

[JoeMo]

I have no experience with the online Excel app, but I believe it does not support VBA.

 

[joelmidiowa]

Okay thanks again for all your help much appreciated!