listview

  1. J

    Finding Date in Listview

    Hi, Is there anyone that can show me how to find in listview control column 2 the earliest date and populate it in textbox 1, and the latest date into textbox 2. Thank you to anyone that can help me.
  2. A

    show the colored value of column in listview

    hi, everyone i have data in sheet1 from range (a:d) , userform contains listview and the column d containes values of colored green and red i would show the colored value of column in list view is there any code do that ?
  3. J

    Highlighted Text

    Hi, I need help. When I check a checkbox I want the text in listview to be highlighted in blue, I am having a problem where whenever I do check the checkbox the text does not highlight blue unless I move my cursor into the listview. Also whenever I check each individual checkbox in the listview...
  4. A

    Listview Control Missing

    I wish to give a workbook to members of our group. It contains a listview control, but it appears that control is Missing (even though it was in the xlsm file I gave them). I thought adding a Reference would fix this, but it appears not. Is there a solution for this? Thanks,
  5. A

    zOrder

    I'm having trouble with zOrder. Is it for Form controls, or not? I see references to shapes but not sure what they are. I've tried msoSendToBack (1), and msoBringToFront (0) each way on a Useform label and listview control and nothing does anything. According to MSHelp there's also...
  6. A

    Listview Control

    Hi, has anyone knowledge of listview controls? Having just set one up on a Userform I'm having a bit of trouble. Can you only detect a click in the first column ? Also if you click another column in say line 3, column 1 in another line may become selected. Is there any way around this? Should...
  7. H

    ListView in Additional Controls - Not Found

    Hi Experts, I am unable to find the ListView control in Additional Control or in Toolbox of Userform. I surfed thru Google and tried a few steps still unable to find it. Please help me where did I go wrong or is their any other solution for this? In our office, we are using: MS Office 2016...
  8. J

    How to Populate ListView With Data Instead of ListBox

    Hi, the code below is working, but there is a small problem with it. I have the data populate a ListBox, but I want the data to populate a ListView. Can someone help with this? I tried to change this code to ListView, but it would not work. So I need someones help with this VBA. Private Sub...
  9. S

    Filtr and search in listview

    Good morning, i have a macro with userform to add , edit delete data and SEARCH in listview i want the code that will help me to search and filtr a data in my LISTVIEW when i click in the button on search . please help me ...:(:(
  10. G

    Iterating Over All Selected Items (rows) in MultiSelect ListView

    Hi, I am using a listview on a user form. I have multi-select enabled. I would like to select multiple items in the listview and then take the value found in some other text boxes and push that into the selected items subitems (columns). The listview is a somewhat new beast to me. I have it...
  11. A

    Excel Listview

    Is it possible to have an listview column show an image (or icon) in certain rows ? if yes, is there an example? I can't find anything on this. Playing around I find switching to either icon view upsets text/layout of the other columns. Must you have either icons or text, not both ?
  12. A

    Listview control

    I have a couple of questions about the Listview control I can't find answers for . Can you hide or set width for 1st column ? It seems to be a special column, not one added by code. At the end of text is "..." even though the width is well within the column width. To remove them you have to...
  13. S

    Listview data in excel

    May I know how I can populate data within the range A1 to F30 in a listview box with Excel VBA
  14. W

    Is MSCOMCTL.OCX installed with MS Office 2016/365?

    I need to use some Windows common controls like ListView in VBA UserForms in Excel. Does anybody know, is MSCOMCTL.OCX implementing the ActiveX interface to those common controls included into the installation of Microsoft Office 2016? And is the situation different in Office 365?
  15. M

    Search in Listview

    Dear Excel wizards I have a listview with six columns. How do I search for a value in the first column? I assume that it's column 0, isn't it? Example to search for value 59: FindItem "59", lvwCustomers, 0, Public Sub FindItem(strSearch As String, lvw As ListView, iSubItemIndex As Integer...
  16. bs0d

    Listbox vs ListView - Excel 2013

    I've read ListView is not available on 64 bit versions of Excel. I feel like I need ListView for the grid-like features. I also hear Listboxes can be formatted in a similar way? Are there still issues with ListView? Are there any good references for formatting Listboxes like tables? I don't want...
  17. P

    Drag Drop From TreeView to ListView ActiveX Controls

    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...
  18. C

    Listview and Webbrowser control problems when placed on Multipage control

    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...
  19. I

    Run macro in Excel that lists only selected items in a listView - Checked

    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...
  20. C

    Adding an icon to a listview column header when sorting by that column

    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...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top