Results 1 to 3 of 3

Doubleclick listbox to open userform

Threaded View

  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?

    Sub Listbox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
          Userform1.Show
    End sub
    Last edited by MB1983DK; 10-05-2015 at 04:47 AM.

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