Dim I as longFor I=0 To Combo.ListCount-1
If Combo.list(I)=…… Then Combo.text=Combo.list(I)
Next I
If Combo.list(I)=…… Then Combo.text=Combo.list(I)
Next I
解决方案 »
- 谁帮我分析下,Case 7 '全部的代码怎么实现
- flash文件播放的声音控制问题
- MSHFlexGrid1.WordWrap字符串换行问题
- 初学者问题,请指教
- 图片的处理,一张比较简单的图片, 用扫描仪扫描入去后。 基于此图片内容比较有规律, 所以想实现加工。加工目标如下:
- 谁能帮我用vb编写一段光盘弹出的代码?万分感谢
- 别人给我的Excel关闭时出现许多Excel表格
- 通过控件数组动态增加的控件能不能删除
- 如何实现MSFlexGrid拖放所选行?或者如何实现组合排序(先按第一列排序再按第二列排序)?
- VB如何打印文档与图片?
- 请问微软专家,如何用程序控制将VCARD文件导入到outlook中?
- 如何在同一台机器运行多份同一数据库管理软件?(安装盘一样,而不会使安装在不同位置的软件指向同一数据源)
Combo1.Text = "bbb"
If Err.Number = 383 Then
MsgBox "无此字符串"
Else
MsgBox Combo1.ListIndex
End If
Dim I ' Declare variable.
For I = 0 To Combo1.ListCount - 1 ' Loop through list.
If Combo1.List(I).Text = string Then 'string 为你要比较的字符串
Combo1.ListIndex = I
Exit For
End If
Next I
on error resume next
以保证List中没有时能捕获错误!
Dim x As New Scripting.Dictionary
Private Sub Form_Load()
Text1.Text = ""
Combo1.AddItem ""
x.Add "", Combo1.NewIndex
Combo1.AddItem "aa"
x.Add "aa", Combo1.NewIndex
Combo1.AddItem "bb"
x.Add "bb", Combo1.NewIndex
Combo1.AddItem "cc"
x.Add "cc", Combo1.NewIndex
End Sub
Private Sub Text1_LostFocus()
Combo1.ListIndex = x.Item(VBA.Trim(Text1.Text))
End Sub
Dim x As New Scripting.Dictionary
Private Sub Form_Load()
Text1.Text = "aa"
Text1.TabIndex = 0
Combo1.AddItem ""
x.Add "", Combo1.NewIndex
Combo1.AddItem "aa"
x.Add "aa", Combo1.NewIndex
Combo1.AddItem "bb"
x.Add "bb", Combo1.NewIndex
Combo1.AddItem "cc"
x.Add "cc", Combo1.NewIndex
End Sub
Private Sub Text1_LostFocus()
Combo1.ListIndex = x.Item(VBA.Trim(Text1.Text))
End Sub
Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal
hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any)
As Long
Public Const CB_FINDSTRING = &H14CPrivate Sub Combo1_Change()
Dim iStart As Integer
Dim sString As String
Static iLeftOff As Integer
iStart = 1
iStart = Combo1.SelStart
If iLeftOff <> 0 Then
Combo1.SelStart = iLeftOff
iStart = iLeftOff
End If
sString = CStr(Left(Combo1.Text, iStart))
Combo1.ListIndex = SendMessage(Combo1.hwnd,B_FINDSTRING, -1, ByVal CStr(Left( ombo1.Text, iStart)))
If Combo1.ListIndex = -1 Then
iLeftOff = Len(sString)
combo1.Text = sString
End If
Combo1.SelStart = iStart
iLeftOff = 0
End Sub
静态变量 iLeftOff 指定了字符长度。
你不是说来源于表吗?
combobox.text=rs("aaa") & ""
& "" 是为了防止NULL出错