★可以编辑的ListView (InkEdit)VBA版2★

office2008 · 发表于 2010-4-25 21:51

同样 ,该版本就是 ListView + InkEdit
'模块代码:

Option Explicit
Public Type POINTAPI 'pt
x As Long
y As Long
End Type
Public Type RECT 'rct
Left As Long
Top As Long
Right As Long
Bottom As Long
End Type
Declare Function GetCursorPos Lib "user32" (lpPoint As POINTAPI) As Long
Declare Function ScreenToClient Lib "user32" (ByVal hWnd As Long, lpPoint As POINTAPI) As Long
Declare Function GetKeyState Lib "user32" (ByVal nVirtKey As Long) As Integer
Declare Function SetParent Lib "user32" (ByVal hWndChild As Long, ByVal hWndNewParent As Long) As Long
Declare Function MapWindowPoints Lib "user32" (ByVal hwndFrom As Long, ByVal hwndTo As Long, lppt As Any, ByVal cPoints As Long) As Long
Declare Function SendMessage Lib "user32" Alias "SendMessageA" _
(ByVal hWnd As Long, _
ByVal wMsg As Long, _
ByVal wParam As Long, _
lParam As Any) As Long
Private Const WM_DESTROY = &H2
Private Const WM_KILLFOCUS = &H8
Private Declare Function GetProp Lib "user32" Alias "GetPropA" (ByVal hWnd As Long, ByVal lpString As String) As Long
Private Declare Function SetProp Lib "user32" Alias "SetPropA" (ByVal hWnd As Long, ByVal lpString As String, ByVal hData As Long) As Long
Private Declare Function RemoveProp Lib "user32" Alias "RemovePropA" (ByVal hWnd As Long, ByVal lpString As String) As Long
Private Declare Function SetWindowLong Lib "user32" Alias "SetWindowLongA" (ByVal hWnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long
Private Const GWL_WNDPROC = (-4)
Public Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, _
ByVal lpWindowName As String) As Long
Private Declare Function CallWindowProc Lib "user32" Alias "CallWindowProcA" (ByVal lpPrevWndFunc As Long, ByVal hWnd As Long, ByVal uMsg As Long, ByVal wParam As Long, ByVal lParam As Long) As Long
Public Declare Function GetFocus Lib "user32" () As Long
Private Const OLDWNDPROC = "OldWndProc"
Public Const LVI_NOITEM = -1
Public Const LVM_FIRST = &H1000
Public Const LVM_GETSUBITEMRECT = (LVM_FIRST + 56)
Public Const LVM_SUBITEMHITTEST = (LVM_FIRST + 57)
Public Const LVIR_ICON = 1
Public Const LVIR_LABEL = 2
Public Type LVHITTESTINFO
pt As POINTAPI
flags As Long
iItem As Long
iSubItem As Long
End Type
Public Const LVHT_ONITEMLABEL = &H4
Public Function ListView_GetSubItemRect(hWnd As Long, iItem As Long, iSubItem As Long, _
code As Long, prc As RECT) As Boolean
prc.Top = iSubItem
prc.Left = code
ListView_GetSubItemRect = SendMessage(hWnd, LVM_GETSUBITEMRECT, ByVal iItem, prc)
End Function
Public Function ListView_SubItemHitTest(hWnd As Long, plvhti As LVHITTESTINFO) As Long
ListView_SubItemHitTest = SendMessage(hWnd, LVM_SUBITEMHITTEST, 0, plvhti)
End Function
Public Function SubClass(hWnd As Long, lpfnNew As Long) As Boolean
Dim lpfnOld As Long
Dim fSuccess As Boolean
If (GetProp(hWnd, OLDWNDPROC) = 0) Then
lpfnOld = SetWindowLong(hWnd, GWL_WNDPROC, lpfnNew)
If lpfnOld Then
fSuccess = SetProp(hWnd, OLDWNDPROC, lpfnOld)
End If
End If
If fSuccess Then
SubClass = True
Else
If lpfnOld Then Call UnSubClass(hWnd)
MsgBox "Unable to successfully subclass &H" & Hex(hWnd), vbCritical
End If
End Function
Public Function UnSubClass(hWnd As Long) As Boolean
Dim lpfnOld As Long
lpfnOld = GetProp(hWnd, OLDWNDPROC)
If lpfnOld Then
If RemoveProp(hWnd, OLDWNDPROC) Then
UnSubClass = SetWindowLong(hWnd, GWL_WNDPROC, lpfnOld)
End If
End If
End Function
Public Function WndProc(ByVal hWnd As Long, ByVal uMsg As Long, ByVal wParam As Long, ByVal lParam As Long) As Long
Select Case uMsg
Case WM_KILLFOCUS
Call CallWindowProc(GetProp(hWnd, OLDWNDPROC), hWnd, uMsg, wParam, lParam)
Call UserForm1.HideTextBox(True)
Exit Function
Case WM_DESTROY
Call CallWindowProc(GetProp(hWnd, OLDWNDPROC), hWnd, uMsg, wParam, lParam)
Call UnSubClass(hWnd)
Exit Function
End Select
WndProc = CallWindowProc(GetProp(hWnd, OLDWNDPROC), hWnd, uMsg, wParam, lParam)
End Function

复制代码

窗体代码:

Private Const SB_HORZ = &H0
Private Const SB_VERT = &H1
Private m_hwndLV As Long ' ListView1.hWnd
Private m_hwndTB As Long ' TextBox1.hWnd
Private m_iItem As Long ' ListItem.Index whose SubItem is being edited
Private m_iSubItem As Long ' zero based index of ListView1.ListItems(m_iItem).SubItem being edited
Private Sub ListView1_DblClick()
Dim lvhti As LVHITTESTINFO
Dim rc As RECT
Dim hWnd As Long
Dim li As ListItem
If (GetKeyState(1) And &H8000) Then 'vbKeyLButton鼠标左键
Call GetCursorPos(lvhti.pt)
Call ScreenToClient(m_hwndLV, lvhti.pt)
If (ListView_SubItemHitTest(m_hwndLV, lvhti) <> LVI_NOITEM) Then
If lvhti.iSubItem Then
If ListView_GetSubItemRect(m_hwndLV, lvhti.iItem, lvhti.iSubItem, LVIR_LABEL, rc) Then
hWnd = FindWindow(vbNullString, Me.Caption)
Call MapWindowPoints(m_hwndLV, hWnd, rc, 2)
Text1.Move (rc.Left) * 15 / 20, rc.Top * 15 / 20, _
(rc.Right - rc.Left) * 15 / 20 + 1, _
(rc.Bottom - rc.Top) * 15 / 20 + 1
m_iItem = lvhti.iItem + 1
m_iSubItem = lvhti.iSubItem
If m_iSubItem > 1 Then
Text1.Text = ListView1.ListItems(m_iItem).SubItems(m_iSubItem)
Text1.Tag = Text1.Text
ListView1.ListItems(m_iItem).SubItems(m_iSubItem) = ""
Text1.ZOrder 0
Text1.Visible = True
Text1.SelStart = 0
Text1.SelLength = Len(Text1.Text)
Text1.SetFocus
'可以用其他程序代替它
Call SubClass(m_hwndTB, AddressOf WndProc)
End If
End If
End If
End If
End If
End Sub
Private Sub Text1_GotFocus()
'ListView1.ListItems(m_iItem).Selected = True
End Sub
Private Sub Text1_Change()
If m_iItem Then Text1.Width = ListView1.ColumnHeaders(m_iSubItem + 1).Width
End Sub
Friend Sub HideTextBox(fApplyChanges As Boolean)
If fApplyChanges Then
ListView1.ListItems(m_iItem).SubItems(m_iSubItem) = Text1
Else
ListView1.ListItems(m_iItem).SubItems(m_iSubItem) = Text1.Tag
End If
Call UnSubClass(m_hwndTB)
Text1.ZOrder 1
'Text1.Visible = False
Text1 = ""
m_iItem = 0
End Sub
Private Sub Text1_KeyPress(Char As Long)
If (Char = vbKeyReturn) Then
Call HideTextBox(True)
Char = 0
ElseIf (Char = vbKeyEscape) Then
Call HideTextBox(False)
Char = 0
End If
End Sub
Private Sub UserForm_Initialize()
m_hwndTB = Me.Text1.hWnd
'Me.Text1.Visible = False
Text1.ZOrder 1
With ListView1
.LabelEdit = lvwManual
.HideSelection = False
.Appearance = cc3D
.Icons = ImageList1
.MultiSelect = True
.Gridlines = True
.View = lvwReport
.FullRowSelect = True
.SmallIcons = ImageList1
m_hwndLV = .hWnd
For i = 1 To 4
.ColumnHeaders.Add Text:="column" & i
Next
For i = &H0 To &HF
Set Item = .ListItems.Add(, , "item" & i, &H1, &H1)
Item.SubItems(1) = i * 10
Item.SubItems(2) = i * 100
Item.SubItems(3) = i * 1000
Next
End With
End Sub

复制代码

[ 本帖最后由 office2008 于 2010-4-27 14:56 编辑 ]

cflood · 发表于 2010-4-25 22:01

怎么使用呢？

fsydw · 发表于 2010-4-25 22:03

迷糊啊！学习中！！谢谢大师分享！！！

飞云楼主 · 发表于 2010-4-26 12:25

谢谢分享。

kumoo · 发表于 2010-4-26 12:48

找不到工程或者库

Private Sub UserForm_Initialize()

menboy · 发表于 2010-4-29 12:16

下来看看，不知道怎么用。

lb_bn · 发表于 2010-4-29 12:43

我的电脑里很多库都没有，郁闷。

缺少的库文件有这些：

MSDATGRD.OCX
MSDATLST.OCX
DBLIST32.OCX
Richtx32.ocx
COMCTL32.OCX

[ 本帖最后由 lb_bn 于 2010-4-29 12:48 编辑 ]

aidixiao · 发表于 2010-4-29 13:13

谢谢分享。

roc.jame · 发表于 2010-6-27 21:53

学习，谢谢分享

camle · 发表于 2010-9-17 09:26

原帖由 kumoo 于 2010-4-26 12:48 发表
找不到工程或者库

Private Sub UserForm_Initialize()

找到了几个ocx文件,附在下面.

[ 本帖最后由 camle 于 2010-9-19 23:26 编辑 ]

		自动登录	找回密码
密码			免费注册

[分享] ★可以编辑的ListView (InkEdit)VBA版2★