Listview.Add No Longer Recognize? Listview.mscomctllib Instead?
So I hadn't done some Vbasic coding in like a month. Then i go to edit my code and find the debugger throwing an error on my listview.add.
I delete the .add and hit the . key to see what the supported methods are and it only shows "MSComctlLib" as my option. But then it throws an error when i try to select that. How did this happen and more importantly how do I get back to normal listview methods?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
[Read] Need Help With Custom Scrollbars On A Listview Control! Or Skinning Listview..
I have been searching for weeks now to find a way to use a custom scrollbar to scroll a listview...
Like this:
Now I use an alternating BG function on my listview and I am currently using the ensurevisible method of scrolling a listview...
Is there a better way?
I will post some example projects if needed...
But how would I use a custom scrollbar on a listview control
Thanks for helping
2 ListView Questions. 1 About Selecting Records. 2 About Adjusting Listview Box Size.
Hi,
I'm changing some of my programs to use a ListView instead of a ListBox.
1. On selecting a record how do I pass the info from the fifth column to another Sub? (I have .FullRowSelect = True)
2. I'm dynamically adjusting the column widths to the maximum length of the data going into the column. Is there a way to dynamically adjust the width of the listview box itself to be the sum of the column widths?
Thanks,
Al.
How To Compare 2 Listviews And Copy Listview Content To Another Listview?
Hi all. I am filling a listview with xml data as shown in code beleow. I am calling this part using timer.What i want at the end of this code to compare listview1 with listview2. If they are diffrent or if listview2 is empty then i copy content of listview1 to listview 2.Otherwise do nothing. could any one show me how i can make such compare an copy?Thanks
1 Code:
Dim objDoc As MSXML2.DOMDocument
Dim objNodelist As IXMLDOMNodeList
Dim objNode As IXMLDOMNode
Dim lvwItem As ListItem
'load the xml document
Set objDoc = New MSXML2.DOMDocument
objDoc.async = False
objDoc.Load "http://localhost/data.php"
'add all the song nodes into a nodelist
Set objNodelist = objDoc.selectNodes("//song")
'Clear the listview
ListView1.ListItems.Clear
'Loop through each song node and add to the list view
For Each objNode In objNodelist
Set lvwItem = ListView1.ListItems.Add(, , objNode.selectSingleNode("artist").Text)
lvwItem.SubItems(1) = objNode.selectSingleNode("name").Text
lvwItem.SubItems(2) = objNode.selectSingleNode("image").Text
lvwItem.SubItems(3) = objNode.selectSingleNode("rating").Text
lvwItem.SubItems(4) = objNode.selectSingleNode("songid").Text
lvwItem.SubItems(5) = objNode.selectSingleNode("totalvotes").Text
Next objNode
''Here i want to compare listview1 with listview2. If it is empty or diffrent if fill it
otherwise i do nothing.
Set lvwItem = Nothing
Set objNodelist = Nothing
Set objDoc = Nothing
Moving A Listview Item And Its Subitems To A New Listview
Hey Guys,
Having a bit of trouble. I am attemping to move a selected item and its subitems from one listview to another. I have no problem getting the contents of the first column, but I can't seem to get the subitems over.
Example: I have this in the first listview:
Code:
|Item |Quanity|Price |PQ |
Bananas 2 $.50 $1.00
Then when I try to move that whole row to the other listview I can only seem to get this:
Code:
|Item |Quanity|Price |PQ |
Bananas
No subitems . Any links or help would be appreciated.
Regards,
Max_Power
Listview; Getting Data (populate Listview) From 2 Tables??
hi!
im using a listview of my program..
where i need popluate the it with data coming from 2 tables, (table 1 and table 2); and where one of the entities in both table are the same...
for instance;
table 1 = stud_genInfo
table 2 = stuf_Offenses
both has the entity= stud_Number..
in which i need to show the stud number in my listview..
how can set (code) to show the Stud_no.?? confused:
can anyone help me with this one?? pls i need ur help, badly...
i would appreciate all the help/suggestions anyone would give..
mauve
-----
btw, this is a snip of my code:
strToday = Format (now, "mmddyyy")
With rsSearch
.Open "SELECT * FROM GenIndo, Offenses WHERE Schedule.Date_Today = '" & strToday & " ' And Schedule.Stud_No =CheckUp.Stud_No", CN, adOpenStatic, adLockPessimistic
If .RecordCount <= 0 Then
lvwSchedule.ListItems.Clear
Else
lvwSchedule.ListItems.Clear
.MoveFirst
Do Until .EOF
Set xlist_item = lvwSchedule.ListItems.Add(, , !Stud_NO) ' this is the line(part) where VB highlights the error
xlist_item.ListSubItems.Add , , (UCase(!Last_Name) & ", " & !First_Name & " " & !Middle_Name)
xlist_item.ListSubItems.Add , , (!Offense)
xlist_item.ListSubItems.Add , , (!Offense_Type)
xlist_item.ListSubItems.Add , , (!Offense_No)
.MoveNext
Loop
End If
.Close
End With
Set rsSearch = Nothing
-------
thank u so much...:
Combine 2 Listview Items Into One Listview
I have 2 listviews that have a different listitems.
ex.
LV 1 LV 2
1. A 1. B
2. C 2. D
3. E 3. F
Is there a way to combine the 2 to another listview so that they all look like this with out doubles of matching items?
ex.
LV 3
1. A
2. C
3. E
4. D
5. E
6. F
Listview Problem; Listview.selecteditem
So, I have a listview that displays a series of things, and refreshes every 10 seconds. (By refresh, I mean it clears itself and re-fills all info from a database)
When it refreshes, I want to check and see if any message was selected before the refresh, and if so, select it again.
Code:
'select nothing...GRRRRrr
For i = 1 To frmQuickCom.lstMessages.ListItems.Count
frmQuickCom.lstMessages.ListItems(i).Selected = False
Next
'Reselect the originally selected item
'if there are
Select Case SelText 'this is passed in when this sub is called'
Case ""
'if there are no messages, don't select any
If frmQuickCom.lstMessages.ListItems.Count > 0 Then
frmQuickCom.lstMessages.SelectedItem.Selected = False
End If
Case Else 'something was selected
For i = 1 To frmQuickCom.lstMessages.ListItems.Count
If SelText = frmQuickCom.lstMessages.ListItems(i).Text Then
Set frmQuickCom.lstMessages.SelectedItem = _
frmQuickCom.lstMessages.ListItems(i)
frmQuickCom.rtfMessage.Text = strMsgTransfer
frmQuickCom.lstMessages.SelectedItem.EnsureVisible
End If
Next
'move the window to show the selected item
End Select
So here's the problem -- even if I set selecteditem.selected = false, Selecteditem still has a value. Is there anyway to actually clear that value entirely? (The reason why I ask -- if a message is deleted, it is leaving the last added item (in the next refresh) as the 'selected' item, even though it gets set to false. If I try to key off of the selecteditem value, then, it returns something.)
Drag Listview, Target Is The Same Listview
Hello,
I would like to let the user set a priority on listviewitems by multiple selecting them and dragging them to the correct priority.
So.. I would like to drag and drop a multiple selection and the target is the same listview.
I hope this makes sence.
patrick.
Combine 2 Listview Items Into One Listview
I have 2 listviews that have a different listitems.
ex.
________________
LV 1 l LV 2 l
l l
1. A l 1. B l
2. C l 2. D l
3. E l 3. F l
_______l_________l
Is there a way to combine the 2 to another listview so that they all look like this with out doubles of matching items?
ex.
_______
LV 1 l
1. A l
2. C l
3. E l
4. D l
5. E l
6. F l
_______l
Drag And Drop From Listview To Another Listview
Hey Guys,
I've think i've tried everything but cant get it to work. I can get it to work to a text box or a list bow but not to another Listview!!
Anyone know how to drag the contents of a listview to another listview??
b
Listview Finditem, Result At Top Of Listview
Hello,
I use the function FindItem in order to find what I want. I have one problem : I would like that the result is at the top of the listview, it means, the first visible, not the first of the complete list.
Thanks you
ListView -Drag&Drop- ListView
Does anybody have an example about how to do a Drag & Drop of items between two ListViews? Any help would be welcome. Thanks, in advance.
How To Filter One ListView To Another ListView<Resolved> I Think
I have a listView that displays the content of an Access Database. So far so good. Now I want to the line items in another ListView based on the content of one field. That's where I get lost. I can check the value of desired field IF that line is highlighted, but How do I cycle thru all the Items to send to my second listview?
Any suggestions?
Sample list:
Author Title Describe In(this is a checkbox) Out(this is a checkbox)
kf4iis How to Fix It How to Fix Things (Unchecked) (Checked)
crude example I know.
Any suggestions would be helpful
Charles
Edited by - kf4iis on 6/2/2004 6:27:40 PM
Select From Listview To Listview
Hello all,
This is what I need:
I have one listbox that is populated on load. When a user selects a record, then I would like all records assoc. with that record to show up in another listview.
eg. User selects BOB from the listview1 and this will populate listview2 with all of bob's other misc info.
By the way, listview2's column headers are set at form load.
Listview To Listview Copy
I'm looking for some sample code that shows you how to copy selected contents from one listview control to another listview control. Can anyone help me out with that?
Thanks much.
MSComctlLib???
Where can i find a reference/explanation about MSComctlLib?
I've started at http://msdn.microsoft.com/library but there are nothing. Even the reference guide has "DataObject" where normally we found MSComctlLib.Property in VB parameters, eg. OLEDragDrop TreeView event.
MSComctlLib ProgressBar
I needed a progress bar. I went to View!Toolbars!Control Toolbox!More Controls!Microsoft ProgressBar Control, version 5.0 (SP2).
I draw it on the screen.
Now what? It shows up nowhere in my module autocomplete selection list when I type "ComctlLib." (It's in the Object Browser as belonging to that.)
How do I use the control if its default name ProgressBar1 is perceived by VBA to be a variable?
The picture of the progress bar looks nice on my spreadsheet, but I can't use it without being able to use the object. Why is there no way to get the object into my statements? Is it just a picture of something? Or can you actually program it?
MSComctlLib.TreeCtrl.2
I use Microsoft Treeview Control 6.0 (SP6) in both Excel and Access. In Excel I can see the properties/methods in the VBA using Ctrl+J (or Ctrl+Space) but in Access I get the wrong list of methods/properties, e.g. properties is missing, and those viewed in the list doesn't exist. Why, and how can I solve this?
I've Uh, Broken Something...MSComctlLib
So I used the Package and deployment wizrd to generate an installation routine for a test app. I foolishly told it NOT to mark some files as shared, and when I uninstalled it, it apparently removed some files that VB needs to run my project.
this line of code:
Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
generates an error that says:
"Project or Library not found"
and then nuttin, el Stoppo. I've tried re-installing VB6, no joy there.
Am I hosed?
Lost Reference To Mscomctllib!!
I have recently saved and recompiled a vb program which worked fine. when i re-open the project in vb however, there are errors during the load and i get the following message in a log file:
Line 54: Class MSComctlLib.ListView of control lvExtractTables was not a loaded control class.
when i look at the listview in the designer, it says it is a picturebox?! i seem to have lost my reference to mscomctllib so that none of the common controls are recognised? anyone know how to fix / why it happened?
cheers
gareth jones
Error With MSComctlLib Components
Hi I have worked on a system for about 4 months now and are using the list view of mscomctl.ocx and other components from mscomct2.
Now all of a sudden I get a compile error: User defined datatype not defined on Private Sub lvSelect_ColumnClick(ByVal ColumnHeader As MSComctlLib.ColumnHeader)
Can annyone please help?
Thanks
ListView Selection Based On Second ListView Selection
I have 2 ListView controls.
ListView1 contains a number of items, for one of which a SubItem contains the number 1.
ListView2 contains 10 items, containing Subitems with numbers 1 to 10.
If I select the item in ListView1, of which the SubItem contains the number 1, I would like the ListView2 selection to change to that which contains the SubItem with the number 1 as well.
thx
How To Get Items From Other Program's Listview To My Program's Listview
Hi, I am not sure how to continue with the coding. that is all i can think of. I am trying to get the list of the items from listview to my program's listview. But can't get any items out of them. What do i have to do ?,. please someone help me. =(
the list view is like this
Image Itemname1
Image Itemname2
Image Itemname3
etc....
ief& = FindWindow("IEFrame", "MSN Chat - Chat Room - Microsoft Internet Explorer")
msn& = FindWindowEx(ief&, 0&, "Shell DocObject View", vbNullString)
ies& = FindWindowEx(msn&, 0&, "Internet Explorer_Server", vbNullString)
ies2& = FindWindowEx(ies&, 0&, "#32770", vbNullString)
a& = FindWindowEx(ies2&, 0&, "atl:37242c08", vbNullString)
b& = FindWindowEx(a&, 0&, "atl:msnchatlistview4", vbNullString)
c& = FindWindowEx(a&, b&, "atl:msnchatlistview4", vbNullString)
d& = FindWindowEx(c&, 0&, "SysHeader32", vbNullString)
MSComctlLib.DataObject (Drag & Drop)
Oh boy.. how am I gonna explain this.... Ummm. OK. I have three custom controls, 2 contain datatables and we'll call these custom controlls Datatable 'A' and Datatable 'B' (the datatable controls they contain are made by infragistics (DataTable8)) and one contains a TreeView.
Datatable 'A's job is to display a manifest of objects which belong to any selected node in the tree. Imagine that tree nodes represent shipping containers, clicking on one of them would result in table 'A' displaying the contents of that container. Easy enough.
Datatable 'B' contains things that can be added to nodes in the tree. Dragging a row from Datatable 'B' to a node in the tree adds that item to that node. If the user has the node they dragged to as the selected node, then Datatable 'A' will refresh and display the newly added item.
From the users standpoint it also makes sense to drag items from Datatable 'B' to Datatable 'A', but adding things to nodes in the tree is really outside the scope of Datatable 'A' so what to do?
The solution that presented itself was to do a 'remote' data drop, in other words have Datatable 'A' echo the data object that was dropped on it (which is of type PVDataTable5.IDTDataObject) back to the Tree via a public Sub in the Tree called 'RemoteDataDrop'. This public sub would push the DataObject to the OLDDragDrop of the tree where it could be processed just as if the item was dropped from Datatable 'B' itself. As you might have guessed, this is where the problem comes in.
Data Type Mismatch.
OK, the next idea was to create a variable of type MSComctlLib.Dataobject and the add items from the object of type PVDataTable5.IDTDataObject to it. Both types have the same methods and both types can have their data extracted as vbcftext items so therefore this should be a way of transferring the data between objects of differing types. Problem is the following;
DIM X As MSComctllib.Dataobject
is perfectly valid but
DIM X As New MSComctllib.Dataobject
Is not, and you will get an 'object or with block variable not defined' (or an error to that effect) if it is only DIMensioned. Anybody got a way around this? Anyone got an alternative suggestion? Any and all help is appreciated.
Looking For Object With ProgID: MSComctlLib.ImageListCtrl.2
Hi All,
I have a user getting "Looking for object with ProgID: MSComctlLib.ImageListCtrl.2" when he runs my program. He's running Win2k.
The only image list I'm using is vbAccelerator's image list (vbaliml6.ocx).
Does this error mean that something else I'm using needs MS' image list control, but that it's not installed on his system?
I'm lost.
Thanks,
Bret Reece
ListView1_ItemCheck(ByVal Item As MSComctlLib.ListItem)
Hey all, ListView1
Below sub is used to check if an item in the listview has been clicked on or off with the checkbox feature of the listview enabled.
ListView1_ItemCheck(ByVal item As MSComctlLib.ListItem)
ByVal item As MSComctlLib.ListItem refers to the text of the first listview column.
Is their a way to access the above sub by listindex instead?
As the contents of the listview may change and leave my program without any way of identifying item As MSComctlLib.ListItem?
Any help appreciated Thanks
Type Mismatch With MSComctlLib.TreeView In Special Case.
Hi.
I have a really strange problem regarding the usage of MSComctlLib.TreeView and a selfmade ActiveX-dll library.
I searched the forum, but there is so much around TreeView problems here, not regarding my situation that I decided to write this post.
I created an VB6 ActiveX-dll library which cointains just this one class:
Code:
VERSION 1.0 CLASS
BEGIN
MultiUse = -1 'True
Persistable = 0 'NotPersistable
DataBindingBehavior = 0 'vbNone
DataSourceBehavior = 0 'vbNone
MTSTransactionMode = 0 'NotAnMTSObject
END
Attribute VB_Name = "Tree"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = True
Option Explicit
Option Compare Text
Private WithEvents objTree As MSComctlLib.TreeView
Attribute objTree.VB_VarHelpID = -1
Public Property Set Tree(parObjTree As Object)
Set objTree = parObjTree
End Property
Public Property Get Tree() As Object
Set Tree = objTree
End Property
Aditionally I referenced the component "mscomctl.ocx" in this project.
Info: I need to use "WithEvents", because I have to catch the events of the object.
Then I made a VB6 client application (standard EXE) which also referenced this "mscomctl.ocx" component.
In the form I placed a tree-object ("uxTreeView") and a button:
Code:
Private Sub uxCommandStoreInLib_Click()
Dim objLibTree As New Lib.Tree
Set objLibTree.Tree = uxTreeView
MsgBox objLibTree.Tree.Name
End Sub
This runs perfect, as long as I use the binaries from my computer.
When I copy the DLL and the EXE to another computer, register the DLL and run the EXE, all is still fine.
But when I open my client-EXE-Project on the second computer, nothing works any more.
I get a type-mismatch error in this line:
Code:
Set objLibTree.Tree = uxTreeView
I need a reference to my 'clients' treeview in my Lib.
And the usage of the datatype "Object" for 'objTree' in the Lib is not possible because of "WithEvents".
Where does this behaviour come from?
What ca I do?
Does anybody have an idea?
Regards,
Atze
Edit:
If wanted, I can provide the full code sample.
Compile Error: User Defined Datatype For MSComctlLib
Rebuild the Project file and it worked. this one was strange for all the referances was still there but not working. Well hope this will help someone....
Hi I have worked on a system for about 4 months now and are using the list view of mscomctl.ocx and other components from mscomct2.
Now all of a sudden I get a compile error: User defined datatype not defined on Private Sub lvSelect_ColumnClick(ByVal ColumnHeader As MSComctlLib.ColumnHeader)
Can annyone please help?
Thanks
Listview Looking Odd
Why does this happend? In this case, it's when i open the window. If i drag another window over it or force it to redraw it looks fine afterwards...
Listview
Is it possible to disable the listview's horizontal scrollbars?
Possible With Listview?
Hi
I have two listview boxes, on is a list of checked items in report view. and the other is a single checked item in a view yet to be determined (whatever will make this work)
I want to be able to drag the singe item from the one list box, and place it between items in the larger list. Preferablly, draggin the item on the larger list will only copy it and not move it. Is this possible?
ListView Help
I want to use a ListView. It has 3 colums and Data has to be put in... how do I get the data in the ListView thingy?
Listview
Hi,
i want to do something but i don't see anyway to do it. In my form, i have a listview with 4 column. The listview contain question information and the first column is the rank of the question. But now, i want to two questions in the listview. I know that i have to set the multiselect property to True. But now, when the questions are selected in the listview, when the user click on the reverse button, how can i make it works. Any suggestion are appreciated.
Also, does he has any way to be able to select only two rows. So when the user has two question selected, he can select an other one.
Thanks in advance for your suggestion
Help About Listview
i have a file text with any move of chess
1. e4 e5 Nf3 Nc6 1/2-1/2
1. e4 c5 Nf3 d6 1/2-1/2
i wanna write program read file text and run it in listview
ex:
when i write it, it show
Moveslist Wins Draw Lost
1. e4 0 2 0
when i click in 1. e4, it show
Moveslist Wins Draw Lost
..e5 0 1 0
..c5 0 1 0
Maybe you can help me about code it. Please
Txt To Listview
hi can anyone help me on how to display txtfile to listview,
sample on the textfile
4/29/05
--------------------------------
name age address telno.
--------------------------------
nicolo 20 phil 123456
olcoin 20 czech 654321
nico 12 ny 123456789
wat i want to do is to transfer them to a listview w/ but only these values
nicolo 20 phil 123456
olcoin 20 czech 654321
nico 12 ny 123456789
thank you so much
Listview
I need some help sending and recieving listview contents over winsock. The server will send 2 columns of listview items (items & subitems) and the client will display those items in a listview just as the server did. Can somebody please help???
Listview
I use listview,DTpicker and and ADODB and Microsoft Access Database. I have field 'tamat'. and field 'tarikh'.
In the listview, I have add column header tarikh, and tamat. Why When I chose a date from DTpicker, only column header 'tarikh' have a value but not column header 'tamat'
Quote:
newDate = DateAdd("d", rec("hari"), DTPicker1)
Set lvItem = lvJadual.ListItems.Add(, , "" & Format(newDate, "dd/mm/yyyy"))
lvItem.ListSubItems.Add , , "" & rec("peruntukan")
Question 2 :
How can I add the day in the date format?
I have field 'tarikh','hari' and 'tamat'
I want to get the value for field tamat by adding its day.For example
Code:
tarikh hari tamat
18/01/2007 7 24/01/2007
The date format is "dd/mm/yyyy"))
Vb6 Listview To Listview Help
Hi Guys,
I want to carry to content in my listview from one form to the other (a wizard type interface). The first form allows the user to select which products he wants(buy product page) from the database. It works by the user entering a productID into the text box and then pressing the 'Buy' button. He can add as many products as he wants. The code for adding to the listview is as follow:
Code:
rs.Open "SELECT * From Product Where ProductID like '" & txtProductID.Text & "%'", cn, adOpenDynamic, adLockOptimistic
'add to first column
Set lstNew = ListView1.ListItems.Add(, , rs.Fields("ProductID").Value)
'add to next column
lstNew.ListSubItems.Add , , rs.Fields("ProductName").Value
lstNew.ListSubItems.Add , , txtQuantity1.Text
lstNew.ListSubItems.Add , , rs.Fields("UnitPrice").Value
lstNew.ListSubItems.Add , , (rs.Fields("UnitPrice").Value * Val(txtQuantity1.Text))
rs.Close
And on load:
Code:
Set rs = New ADODB.Recordset
With ListView1
.ColumnHeaders.Add , , "Product ID"
.ColumnHeaders.Add , , "Product Name"
.ColumnHeaders.Add , , "Quantity"
.ColumnHeaders.Add , , "Unit Price"
.ColumnHeaders.Add , , "Total Price"
.View = lvwReport
'optional here
.MultiSelect = True
.GridLines = True
End With
Now, when the user presses next it will take him to the invoice page. What I plan on doing is having a listview there too, and carry the content from the 'buy product page' listivew to the invoice page listview. So far this is what I have done:
Code:
Dim i As Long
Dim lvwItem As ListItem
For i = 1 To frmProductinfo.ListView1.ListItems.Count
If ListView1.ListItems(i).Selected = True Then ' if selected then
' add to other list
Set lvwItem = ListView2.ListItems.Add(, , frmProductinfo.ListView1.ListItems.Item(i).Text)
lvwItem.SubItems(1) = frmProductinfo.ListView1.SelectedItem.SubItems(1)
lvwItem.SubItems(2) = frmProductinfo.ListView1.SelectedItem.SubItems(2)
lvwItem.SubItems(3) = frmProductinfo.ListView1.SelectedItem.SubItems(3)
lvwItem.SubItems(4) = frmProductinfo.ListView1.SelectedItem.SubItems(4)
End If
Next
It works, but the problem is that it only adds the row which has been selected and ignores the other rows. Whereas I want to export the entire listview contents into the invoice page listview. How can I fix this ?
ListView Help
Hello! I'm using a listview (report style)
I just want to know how to edit it
Look at the attached picture. How to change that?
Listview Help
Is there an easy way to copy an entry in a listview?
ListView Help
I have a listview on my form, and I set the colums where i can click and drag the colums where i want them, but if i want to drag a colum from the far right to far left how can i make the grid auto move as i'm draggin the colum without having to press my left arrow to make the grid go to the left?
Listview ??
Hi there,
I'm trying to set a method for the Mousedown in a Listview control using Access/VBA, this is what I'm trying:
My Listivew Control is Called lvwLabour
Code:
Private Sub LvwLabour_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
'
'
'
End Sub
All i get is this
Quote:
Compiler Error:
Procedure Declaration does not match description of event or procedure having the same name
.
In Access it seems that you only have access (visual that is ) to several method events:
On Update, On Enter, On Exit, On Got focus, On Lost Focus why is that because in the code properties window(vba), it shows OnMouseDown property but you cannot do anything with it(no dropdown selection).
the pig..
|