Results 1 to 10 of 10

Thread: if there is any third party dropmenu as like excel combobox ?

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Jun 2017
    Posts
    236

    if there is any third party dropmenu as like excel combobox ?

    if there is any third party dropmenu as like excel combobox ?
    (1) can drop down menu (2) menu with scroll bar


    GIF show

    https://i.imgur.com/9gpqlfb.gif



    Code:
    Private Sub Form_Load()
    For w = 1 To 100
    EXCEL_ComboBox1.AddItem w
    Next
    EXCEL_ComboBox1.Visible = 0
    End Sub
    
    Private Sub Form_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
    EXCEL_ComboBox1.Move X, Y - EXCEL_ComboBox1.Height
    EXCEL_ComboBox1.DropDown
    End Sub
    Last edited by quickbbbb; Jan 19th, 2018 at 07:37 AM.

  2. #2
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    Re: if there is any third party dropmenu as like excel combobox ?

    i am not really sure what you want, but you can check this thread http://www.vbforums.com/showthread.p...ms-To-UserForm
    i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
    Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

    dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part

    come back and mark your original post as resolved if your problem is fixed
    pete

  3. #3
    PowerPoster
    Join Date
    Jul 2010
    Location
    NYC
    Posts
    5,654

    Re: if there is any third party dropmenu as like excel combobox ?

    Well that's not really a menu that's just popping up a combobox where the mouse is. You could do that with a standard VB combobox; make a new form that's just a combobox, on the first form right click, set left and top to where the mouse is, then pop up your combobox form at that location. There's fancier ways but that will get the job done without a bunch of API.

  4. #4

    Thread Starter
    Addicted Member
    Join Date
    Jun 2017
    Posts
    236

    Re: if there is any third party dropmenu as like excel combobox ?

    It is a big flaw.

    When VB new form popup , host form will lost focus.

    When Excel_Combbox popup , host form will not lost focus.

  5. #5
    Frenzied Member
    Join Date
    Jun 2014
    Posts
    1,084

    Re: if there is any third party dropmenu as like excel combobox ?

    have you tried vb's popupmenu method ?
    do not put off till tomorrow what you can put off forever

  6. #6

    Thread Starter
    Addicted Member
    Join Date
    Jun 2017
    Posts
    236

    Re: if there is any third party dropmenu as like excel combobox ?

    yes , but vb's popupmenu has no scrollbar

    Flaw of excel combbox is must install MS office and not support mouse wheel

  7. #7
    PowerPoster
    Join Date
    Feb 2006
    Posts
    24,482

    Re: if there is any third party dropmenu as like excel combobox ?

    What about something in a custom UserControl?

    Lots of fiddling, incomplete... but it does appear to handle your funky requirements. An idea to get you started if nothing else.

    Name:  sshot.png
Views: 128
Size:  5.1 KB
    Attached Files Attached Files
    Last edited by dilettante; Jan 21st, 2018 at 11:26 PM.

  8. #8

    Thread Starter
    Addicted Member
    Join Date
    Jun 2017
    Posts
    236

    Re: if there is any third party dropmenu as like excel combobox ?

    dilettante , That’s impressive!
    Last edited by quickbbbb; Jan 22nd, 2018 at 02:19 AM.

  9. #9
    PowerPoster ChrisE's Avatar
    Join Date
    Jun 2017
    Location
    Frankfurt
    Posts
    3,046

    Re: if there is any third party dropmenu as like excel combobox ?

    Hi quick,

    what's the purpose of a "flying about Combo", that would drive me crazy as a User, well but that's
    just me

    regards
    Chris
    to hunt a species to extinction is not logical !
    since 2010 the number of Tigers are rising again in 2016 - 3900 were counted. with Baby Callas it's 3901, my wife and I had 2-3 months the privilege of raising a Baby Tiger.

  10. #10

    Thread Starter
    Addicted Member
    Join Date
    Jun 2017
    Posts
    236

    Re: if there is any third party dropmenu as like excel combobox ?

    hi ChrisE

    Let vb listview has dropdown list

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width