+ Reply to Thread
Results 1 to 4 of 4

Double-click a listbox inside a group

  1. #1
    Forum Contributor
    Join Date
    10-11-2013
    Location
    Austria
    MS-Off Ver
    Excel 2010
    Posts
    136

    Double-click a listbox inside a group

    some idiot (could have been me...) decided to group a whole lot of objects on a sheet, one of which is a list box that had a DblClick function on it.

    Please Login or Register  to view this content.
    was the sub that used to run it, which now can't find the listbox because it's buried in a group!

    to populate it I use something like

    Please Login or Register  to view this content.
    is there a way to assign that dblclick to this box? or re-write it for it?

  2. #2
    Forum Contributor
    Join Date
    10-11-2013
    Location
    Austria
    MS-Off Ver
    Excel 2010
    Posts
    136

    Re: Double-click a listbox inside a group

    For some reason changing the name of the listbox helped!

    All working as planned.

  3. #3
    Forum Contributor
    Join Date
    06-23-2014
    Location
    Dubbo, Australia
    MS-Off Ver
    EXCEL 2019
    Posts
    180

    Re: Double-click a listbox inside a group

    Hey RodgerSubMachineGun, want to post the end result code so everyone understands how you fixed it?
    Pete
    Struggling Solutions Architect

  4. #4
    Forum Contributor
    Join Date
    10-11-2013
    Location
    Austria
    MS-Off Ver
    Excel 2010
    Posts
    136

    Re: Double-click a listbox inside a group

    For sure! I really didn't do anything to the code itself though. I noticed that the listbox I was looking for wasn't in the object list, so changed the name and there it was. then selected the dblclick event on the right side.
    it all looks like this now:
    Please Login or Register  to view this content.

+ 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. [SOLVED] Move rows from one listbox to another by double click
    By Littlefarmer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2015, 10:39 AM
  2. Update data by click inside listbox
    By Nisar.mohammed in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-28-2015, 09:22 AM
  3. [SOLVED] Double Click Listbox question
    By frostii in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2015, 09:15 PM
  4. Double click Listbox to edit item
    By johan12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2012, 04:12 AM
  5. Replies: 3
    Last Post: 08-10-2011, 02:02 PM
  6. double click option in listbox outputs to cell in excel 97 !
    By spyrule in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2006, 12:05 AM
  7. Need selected item from listbox after double click
    By peterfarge@hotmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2006, 11:20 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