+ Reply to Thread
Results 1 to 7 of 7

Adding Controls to a userform Listview

  1. #1
    Valued Forum Contributor Macdave_19's Avatar
    Join Date
    03-14-2007
    Location
    Birmingham, England
    MS-Off Ver
    12.0
    Posts
    808

    Question Adding Controls to a userform Listview

    Hi All,

    I'm learning how to use listviews on a userform.

    Is it possible to add a dropdown list to a certain field on the listview?

    If so could someone post a simplified example please?

    Cheers
    Last edited by Macdave_19; 08-29-2012 at 07:23 AM. Reason: No Answer
    Mr MaGoo
    Magoo.Inc MMVII

    If i've helped please add to my Rep by Clicking on the Blue Scales in the top right hand corner of the post

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,282

    Re: Adding Controls to a userform Listview

    No, not as far as I know - at least not without using APIs to create and position a combobox over the selected item.
    Remember what the dormouse said
    Feed your head

  3. #3
    Valued Forum Contributor Macdave_19's Avatar
    Join Date
    03-14-2007
    Location
    Birmingham, England
    MS-Off Ver
    12.0
    Posts
    808

    Re: Adding Controls to a userform Listview

    Hi Romper,

    Don't suppose you show me the "long way" then would you?? pretty please?

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,282

    Re: Adding Controls to a userform Listview

    Nope - never had occasion to do it and don't have time to work on that sort of thing! Andy might have some similar code as I think he uses that basic principle in his multi-coloured listbox demo. Not even sure if it's possible to be honest - may depend on whether you could get a handle to the treeview.

  5. #5
    Valued Forum Contributor Macdave_19's Avatar
    Join Date
    03-14-2007
    Location
    Birmingham, England
    MS-Off Ver
    12.0
    Posts
    808

    Re: Adding Controls to a userform Listview

    Ok buddy now worries, cheers anyways

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,441

    Re: Adding Controls to a userform Listview

    here is a quick bodge using the example RS mentioned.

    Select an item in the listview to display the dropdown control.
    Select item from drop down by double clicking. Resulting colour name is updated in the listview subitems text.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  7. #7
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,282

    Re: Adding Controls to a userform Listview

    Cheers Andy.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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