这个代码可真费了我不少功夫! -_-!!! '需要添加WebBrowser控件并引用Microsoft HTML Object LibraryDim WithEvents webDoc As HTMLDocument Dim webTag As Object Dim WithEvents objTD As HTMLTableCell, WithEvents objText As HTMLInputTextElement Dim lengthTag As Integer Dim countTag As Integer Dim bMoved As BooleanPrivate Sub Form_Load() web.Navigate "about:blank" web.Document.write "<table width=100% border=1><tr><td id=test align=center>TD里原内容</td></tr></table>" Set webDoc = web.Document lengthTag = webDoc.All.length - 1 For countTag = 0 To lengthTag Set webTag = webDoc.All.Item(countTag) If LCase(webDoc.All.Item(countTag).tagName) = "td" Then If webTag.Id = "test" Then Set objTD = webTag End If End If Next End SubPrivate Sub objTD_onmousemove() If Not bMoved Then bMoved = True web.Document.body.innerHTML = "<table width=100% border=1><tr><td id=test align=center><form id=form1 name=form1 method=post><input name=textfield type=text maxlength=10></form></td></tr></table>" Set webDoc = web.Document lengthTag = webDoc.All.length - 1 For countTag = 0 To lengthTag Set webTag = webDoc.All.Item(countTag) If LCase(webDoc.All.Item(countTag).tagName) = "input" Then If webTag.Name = "textfield" Then Set objText = webTag End If End If Next End If End SubPrivate Sub objText_onmouseleave() If objText.Value <> "" Then Debug.Print objText.Value '此处加入保存到数据库的代码即可 web.Document.body.innerHTML = "<table width=100% border=1><tr><td id=test align=center>输入完毕</td></tr></table>" End If End Sub
'需要添加WebBrowser控件并引用Microsoft HTML Object LibraryDim WithEvents webDoc As HTMLDocument
Dim webTag As Object
Dim WithEvents objTD As HTMLTableCell, WithEvents objText As HTMLInputTextElement
Dim lengthTag As Integer
Dim countTag As Integer
Dim bMoved As BooleanPrivate Sub Form_Load()
web.Navigate "about:blank"
web.Document.write "<table width=100% border=1><tr><td id=test align=center>TD里原内容</td></tr></table>"
Set webDoc = web.Document
lengthTag = webDoc.All.length - 1
For countTag = 0 To lengthTag
Set webTag = webDoc.All.Item(countTag)
If LCase(webDoc.All.Item(countTag).tagName) = "td" Then
If webTag.Id = "test" Then
Set objTD = webTag
End If
End If
Next
End SubPrivate Sub objTD_onmousemove()
If Not bMoved Then
bMoved = True
web.Document.body.innerHTML = "<table width=100% border=1><tr><td id=test align=center><form id=form1 name=form1 method=post><input name=textfield type=text maxlength=10></form></td></tr></table>"
Set webDoc = web.Document
lengthTag = webDoc.All.length - 1
For countTag = 0 To lengthTag
Set webTag = webDoc.All.Item(countTag)
If LCase(webDoc.All.Item(countTag).tagName) = "input" Then
If webTag.Name = "textfield" Then
Set objText = webTag
End If
End If
Next
End If
End SubPrivate Sub objText_onmouseleave()
If objText.Value <> "" Then
Debug.Print objText.Value
'此处加入保存到数据库的代码即可
web.Document.body.innerHTML = "<table width=100% border=1><tr><td id=test align=center>输入完毕</td></tr></table>"
End If
End Sub