+ Reply to Thread
Results 1 to 4 of 4

Problem with Listview display in userform

  1. #1
    Registered User
    Join Date
    04-10-2013
    Location
    Nottingham, England
    MS-Off Ver
    Excel 2003
    Posts
    39

    Problem with Listview display in userform

    Hello,
    I've got problems with VBA code to display the format of listbox in a userform.

    The error relates to the [.gridlines=True#] syntax in the VBA code - 'compile error - method or data member not found'.

    I notice when looking at the Listview properties box when viewing the object, I cannot find the custom option, enabling me to add extra options for format.

    The first userform in the workbook with a Listview box with similar code seems to open and work OK.
    Last edited by Jonno1; 02-11-2014 at 08:11 AM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Problem with Listview display in userform

    Hi Jonno,

    Do you have a rowsource filled in for this listbox? See: http://social.msdn.microsoft.com/For...a?forum=isvvba
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Problem with Listview display in userform

    Are you using Listbox or Listview? They are not the same.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  4. #4
    Registered User
    Join Date
    04-10-2013
    Location
    Nottingham, England
    MS-Off Ver
    Excel 2003
    Posts
    39

    Re: Problem with Listview display in userform

    Sorry my mistake, I've added a Listview to the userform design command box, works ok now.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to display item in listview
    By siobeh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2014, 01:14 PM
  2. [SOLVED] add listView to userform programatically
    By contaminated in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-21-2012, 05:11 PM
  3. Replies: 15
    Last Post: 02-07-2012, 11:39 AM
  4. Help - Getting Data into Userform ListView
    By Paparasee in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-03-2011, 03:51 AM
  5. [SOLVED] Adding icons to a listview on a userform
    By Richard in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1