+ Reply to Thread
Results 1 to 3 of 3

Doubleclick listbox to open userform

  1. #1
    Registered User
    Join Date
    11-17-2014
    Location
    Copenhagen, Denmark
    MS-Off Ver
    MS Office 2010
    Posts
    14

    Doubleclick listbox to open userform

    Hey.

    How can I open a userform from doubleclicking on some items in a listbox (control form)?

    The code below doesn't seem to work. Or will it only work if the listbox is an ActiveX form?

    Please Login or Register  to view this content.
    Last edited by MB1983DK; 10-05-2015 at 04:47 AM.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Doubleclick listbox to open userform

    Controls from the Forms toolbox don't really have events, to run code from them you assign a macro.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    11-17-2014
    Location
    Copenhagen, Denmark
    MS-Off Ver
    MS Office 2010
    Posts
    14

    Re: Doubleclick listbox to open userform

    Thanks. I'll work around that then.

+ 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. opening a hyperlink file from listbox doubleclick
    By reploglejj in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-22-2015, 04:50 PM
  2. Another worksheet open corrupts userform listbox
    By chin67326 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-20-2014, 10:12 PM
  3. [SOLVED] Populating a UserForm ListBox with all Open workbooks
    By JoshExcel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-09-2014, 09:30 PM
  4. [SOLVED] Open listbox and doubleclick one line and run macro
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-18-2013, 12:33 PM
  5. Doubleclick an item in listbox (userform)
    By Ray316 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-21-2011, 03:30 PM
  6. Doubleclick in a multicolumn listbox and get the column index?
    By peter233 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-15-2008, 06:31 AM
  7. Listbox doubleclick launch
    By HK in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-02-2006, 12:10 PM

Tags for this Thread

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