+ Reply to Thread
Results 1 to 6 of 6

Listview Subitems editable

  1. #1
    Registered User
    Join Date
    02-19-2013
    Location
    Cebu, Philippines
    MS-Off Ver
    Excel 2010
    Posts
    88

    Listview Subitems editable

    Hello,

    Can we make Listview subitems editable by double clicking?

    its like Listviewsubitems .LabelEdit = lvwAutomatic

    instead of listitem only, subitems will also be editable.

    Is there a way?


    big thanks

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: Listview Subitems editable

    This question is not much different than the previous one.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    02-19-2013
    Location
    Cebu, Philippines
    MS-Off Ver
    Excel 2010
    Posts
    88

    Re: Listview Subitems editable

    the first column in Listview can be editable, you can manually type any text in the first column by

    .LabelEdit = lvwAutomatic

    I'm trying to apply this to subitems in Listview.

    My prior inquiry is putting combobox in listview. But here, I'm just trying to make subitems allow user to type in any text.

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Listview Subitems editable

    There is no setting for that. You would have to add another control for editing and position it appropriately when the item is clicked. Not trivial, in my opinion.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  5. #5
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: Listview Subitems editable

    I suggest you give your BFF Google a chance
    Found these articles (and may more)
    https://docs.microsoft.com/en-us/dot...stview-control
    https://msdn.microsoft.com/en-us/lib...code-snippet-1

  6. #6
    Registered User
    Join Date
    02-19-2013
    Location
    Cebu, Philippines
    MS-Off Ver
    Excel 2010
    Posts
    88

    Re: Listview Subitems editable

    Thank you guys for your help...

+ 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. Problem clicking subitems in listview to open a userform
    By marcoexcel16 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-12-2016, 05:14 AM
  2. editable listbox
    By rlinares67 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-02-2015, 11:19 AM
  3. [SOLVED] Editable areas
    By batya in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-09-2014, 12:33 AM
  4. Editable list box
    By bharathy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-20-2013, 07:11 AM
  5. Listview checked row delete line in Listview and in worksheet data
    By madforit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2012, 01:00 PM
  6. Pop up, editable text box?
    By rriiser in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 05-18-2011, 06:27 AM
  7. editable list
    By NewTooExcel in forum Excel General
    Replies: 0
    Last Post: 08-02-2007, 08:52 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