Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ListView selection
Hello,
How do I allow a user to selrct the content of a ListView and copy it by a RightClick Thanks Avi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ListView selection
ListView is not a built in function of VBA. You would have to construct the
list in Excel and then develop the controls and code for a user to display it by clicking a button or using a keyboard command key. "avi" wrote: Hello, How do I allow a user to selrct the content of a ListView and copy it by a RightClick Thanks Avi |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ListView selection
On Oct 7, 6:54 pm, JLGWhiz wrote:
ListView is not a built in function of VBA. You would have to construct the list in Excel and then develop the controls and code for a user to display it by clicking a button or using a keyboard command key. "avi" wrote: Hello, How do I allow a user to selrct the content of a ListView and copy it by a RightClick Thanks Avi Hello Avi, Here is a sample of List View I used in VBA. My UserForm had a ListView and 3 TextBoxes. This is taken from the Click event... Private Sub ListView1_ItemClick(ByVal item As MSComctlLib.ListItem) Dim RowNumber RowNumber = item.Index With ListView1.ListItems(RowNumber) TextBox1.Text = .Text TextBox2.Text = .SubItems(1) TextBox3.Text = .SubItems(2) .EnsureVisible End With End Sub The Text property returns the item in the first column. Each additional column is designated by the SubItems property. To JLGWhiz - the ListView control can be added by going to "Additional Controls..." under Tools menu in the VBIDE. You must have a UserForm in your project selected and the control toolbox visible to access these controls. Sincerely, Leith Ross |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
ListView selection
Tanks
Avi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ListView information | Excel Programming | |||
Listview Question | Excel Programming | |||
ListView Question | Excel Programming | |||
bug listview? | Excel Programming | |||
How to use Listview control | Excel Programming |