listview

Trying to drag a child node only from a ActiveX TreeView Control to an ActiveX ListView control in VBA for Excel. It works occasionally, but something is wrong. I'm unable to consistently get the drag event to fire (sometimes it works, sometimes not) or, when it does, determine what was selected...

Just wondering whether anyone has come across this issue, and if so has any solutions? I am currently building a dashboard which utilises a userform, on which there is a multipage control. On a number of pages of the multipage (but not all), there is a listview control or a webbrowser control...

Run macro in Excel that lists only selected items in a listView - Checked I need to run a macro that travels a listview and perform a certain task only for rows with checked equals true. Thanks if you can help! Ivair Claudio Ferrari Excelmax Soluções, Excel, Software, Simulador, Gráfico...

Hi, I'm hoping an Excel guru on here can help me with a couple of problems that I've not been able to figure out. I've designed a spreadsheet for work that uses a listview to display data that is held on a sheet (this is taken from a textfile stored on a network drive). The data is 18000 rows...

Hi all, I'm just bouncing for ideas here, but I basically need to find a way of using a ListBox look a bit prettier than it currently does. I am pulling information from an Access database into Excel and I need to display a large volume of information in an easy to read manner - the easiest of...

Hello I'm working on a project which involves userforms and listviews. I use a hidden sheet to get a customer's data (date, shopping date etc). The data is fetched as soon as a customerID is put into cell BN41 with an advanced filter. That works OK. The problem is populating the listview with...

Hi, Not sure if this is possible, but is there any way of inserting a horizontal line between rows of data in a Listview control on a userform? At present the listview displays data as below: Title 1 Title 2 Title 3 Data1 Data 2 Data 3 ... ... TOTALS Total 1 Total 2 The...

Hi, On VBA form I am using two listview controls(Listview version 6.0 from MSCOMCTL.OCX). I want to bind both listviews scrollbar together, so if I scroll one list view, other should scroll too. I think that is not possible with native VBA.But.. This could be done through using win32 API...

Hello All, Thank you in advance for any help offered on this most frustrating problem. Details I have a Userform with a listview on it. The user selects a row using the Up+Down arrows, then presses Enter to add detail to that row. This shows a second userform with controls for the info. My...

I have an Excel sheets that contains three columns. Column A = First Name Column B = Last Name Column C = State I created a ListView and have created the 3 column headers. However, I don't know how to populate all the columns. Do I need to assign a key to each column? If so, how? I appreciate...

Hello, I have been trying searching for an answer on the problem I got, but there seem to be no easy solution and hopefully someone on this forum can help. Problem: I am trying to make a form in word where the user can type in text and next to it, change the status between green, yellow and...

Hi, I am trying to print the items which I have entered into a Listview box. At the moment all the data entered appears in the text box and all the calculations are completed successfully. However when i try to print the data in the listview it comes up with the title and the date just as I want...

Is it possible to view listview starting from the 120th item when it initializes. I have a varying listview containing past,present and future transactions. These transactions are sorted into date order. What I would like is for when the listview initialises it starts its view in the middle ie...