listview in vba

  1. R

    Scroll 2 listview at the same time, Excel VBA, help please

    Hi all, I have this problem, I have 2 listview in 1 userform in excel, I can't combine the listview list, but both listviews is correlated. so I need to fine a way, to scroll them at the same time, how to do that? [/URL] free image uploading[/IMG] Please help, if this can be achieve...
  2. 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...
  3. C

    Listview issue

    Can anyone help me with the following? I have a userform that utilizes a listview control to display a range of cells from a worksheet. Initally this range is around 7000 rows by 75 columns. Via the use of various other controls, users can then filter this list to whatever they require. My...
  4. C

    ListView Query

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

    Listview Control with Check Boxes

    Hi Everyone, I've added a Listview control with check boxes on the second page of my Multipage. Everything works fine except disappearing. When selecting among pages. This is on a Excel user form. Not sure what is going on. My environment is: Win XP with SP3 3Office 2007 with SP2 Any...

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