Excel Beep

[rivergum]

Hi All,
I have been playing around with VB code to try and get a beep into my excel sheet.... With no luck

What I'm trying to do is the following;

When my if statement in column P outputs "OK" I want to be able to hear a "beep" from the computer and similarly when the same formula outputs "BAD" the computer gives me 2 beeps.

Is this possible??

Thanks in advance,
River

[jaslake]

Hi River
Try

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[rivergum]

Hi Jaslake,
Cheers, thanks for that suggestion... However that was the bit I could actually get happening , it was more getting my IF statement code correct to read the "OK" or "BAD" out of my column P.

Here is my code.... I'm just not exactly sure how to get it too look at P column only;

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A1") = "OK" Then
Beep
Else
Beep
Application.Wait (Now + TimeValue("0:00:02"))
Beep
End If

End Sub

River

[jaslake]

Hi River

You're new to the Forum but not that new. You've gotta use Code Tags around your code. Can't respond 'till you do.

[rivergum]

Hi John,
Sorry didn't know how to do that. All fixed up now.

Cheers,
River

[jaslake]

Hi River

Well...you used Quote Tags not Code Tags. You can fix that. In the meantime you reference

it was more getting my IF statement code correct to read the "OK" or "BAD" out of my column P.

yet your code references

Please Login or Register  to view this content.

So what's your actual code and what column are we referencing?
How does Column A (or Column P) get changed to "OK" or "Bad"...by user input? Change Event code is the correct approach but I'm not "seeing" what you want. A dummy file would be helpful.

[mikerickson]

You might use this UDF.
Put =MakeBeep(OR(P1="OK,P1="Bad"), 1+(P1="Bad"), "something") in a cell.

Please Login or Register  to view this content.

[rivergum]

Hi Guys,
I see I have made a typo in my orignal post regarding the column I require...

So as you can see via the attached workbook in column A is the results column of B and C using a simple IF statement.

So the problem is that as you can see the beep or beep beep works in every column in the sheet not just in column A like I would like it to. So I'm not sure how to get the VB code to only look at column A and not the rest of the sheet.

Please help!!

Thanks Heaps.

River

[royUK]

You've used Quote Tags, not Code Tags

[rivergum]

Please Login or Register  to view this content.

Hi Guys,
I see I have made a typo in my orignal post regarding the column I require...

So as you can see via the attached workbook in column A is the results column of B and C using a simple IF statement.

So the problem is that as you can see the beep or beep beep works in every column in the sheet not just in column A like I would like it to. So I'm not sure how to get the VB code to only look at column A and not the rest of the sheet.

Please help!!

Thanks Heaps.

River

[Kenneth Hobson]

Your formula for A2 should probably be:
=IF(AND(B2="OK",C2="OK"),"OK","BAD")
and if so, change the others as well.

Please Login or Register  to view this content.

[rivergum]

Hi Kenneth,
Thank you very much for your and everybody's help on this one!! Works perfect!!

Cheers,
River