Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a VBA form which has a listbox. When dragging a file, folder or
computer from Explorer to the list box, in the BeforeDragOver event handler, calling GetFormat on the DataObject always returns false. What am I doing wrong? My code follows. It is just trying to determine what format values different DataObjects supoort. Thanks in advance for any help. -John Private Sub lstMachines_BeforeDragOver(ByVal Cancel As MSForms.ReturnBoolean, ByVal Data As MSForms.DataObject, ByVal X As Single, ByVal Y As Single, ByVal DragState As MSForms.fmDragState, ByVal Effect As MSForms.ReturnEffect, ByVal Shift As Integer) Dim bRes As Boolean Dim i As Long For i = -32767 To 32767 bRes = Data.GetFormat(i) If (bRes) Then MsgBox "Format " & i End If Next i End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error using DataObject to get clipboard data | Excel Discussion (Misc queries) | |||
DataObject Error in Excel version 2002 | Excel Programming | |||
How do I reference "DataObject"? | Excel Programming | |||
DataObject and cliboard | Excel Programming | |||
Can't Dim As DataObject?? | Excel Programming |