a AutoComplete Very Simple! - نسخة قابلة للطباعة

كود :
                '**************************************

' Name: a AutoComplete Very Simple!

' Description:VERY SIMPLE cut and paste funtion for the Keypress event of a combobox. Just paste this code into a module or form and call the function from the KeyPress event. KeyAscii = AutoComplete(cboCombobox, KeyAscii,Optional UpperCase)

' By: ( . Y . ) (from psc cd)

'**************************************



Option Explicit

Public Const CB_FINDSTRING = &H14C

Public Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As Long

Function AutoComplete(cbCombo As ComboBox, sKeyAscii As Integer, Optional bUpperCase As Boolean = True) As Integer

 Dim lngFind As Long, intPos As Integer, intLength As Integer

 Dim tStr As String

 With cbCombo

 If sKeyAscii = 8 Then

 If .SelStart = 0 Then Exit Function

 .SelStart = .SelStart - 1

 .SelLength = 32000

 .SelText = ""

 Else

 intPos = .SelStart '// save intial cursor position

 tStr = .Text '// save string

 If bUpperCase = True Then

 .SelText = UCase(Chr(sKeyAscii)) '// change string. (uppercase only)

 Else

 .SelText = UCase(Chr(sKeyAscii)) '// change string. (leave case alone)

 End If

 End If

 

 lngFind = SendMessage(.hwnd, CB_FINDSTRING, 0, ByVal .Text) '// Find string in combobox

 If lngFind = -1 Then '// if string not found

 .Text = tStr '// set old string (used for boxes that require charachter monitoring

 .SelStart = intPos '// set cursor position

 .SelLength = (Len(.Text) - intPos) '// set selected length

 AutoComplete = 0 '// return 0 value to KeyAscii

 Exit Function

 

 Else '// If string found

 intPos = .SelStart '// save cursor position

 intLength = Len(.List(lngFind)) - Len(.Text) '// save remaining highlighted text length

 .SelText = .SelText & Right(.List(lngFind), intLength) '// change new text in string

 '.Text = .List(lngFind)'// Use this instead of the above .Seltext line to set the text typed to the exact case of the item selected in the combo box.

 .SelStart = intPos '// set cursor position

 .SelLength = intLength '// set selected length

 End If

 End With

 

End Function