IBM/Lenovo Laptop Beeps. Very Loud.

IBM/Lenovo Laptop Beeps. Very Loud.

These beeps come from 3 places. Do not try to recreate these wearing headphones as it might hurt your ears.

1. Pressing 3 keys at once
2. Battery related beep
3. Changing volume beep.

All three can be disabled.

1. Press Function and Backspace

2. Modify in the Battery settings
Power Manager, then Global Power Settings tab, and deselect “Beep on power state changes.”

3. Open Thinkpad configuration and disable the beep after selecting audio properties, bottom left. Alternatively, in control panel, find the device manager, show hidden devices, in the Non-plug and play list disable the one named Beep.

Information from here
http://www.lenovoblogs.com/insidethebox/?p=42

RightBack

Option Compare Text
Function RightBack(strBigString As String, strSmallString As String) As String
' Finds the text after a string
' eg =RightBack( "I love life and other stuff, do you", "," ) returns " do you"

Dim lngIndexOf As Long

lngIndexOf = InStrRev(strBigString, strSmallString)
If lngIndexOf = 0 Then
strRightBack = ""
Else
strRightBack = Mid(strBigString, lngIndexOf + 1)
End If ' we found one instance


RightBack = strRightBack

End Function

Function InStrRev2(strBigString As String, strSmallString As String) As Long
InStrRev2 = InStrRev(strBigString, strSmallString)

End Function
http://www.ozgrid.com/Excel/find-nth.htm