Combobox
Combobox
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Combobox

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hello
    Does anyone know how to add a column of items to the combobox alphabatically and elimate the duplicated ones?
    Thanks in advance

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can someone please help me...
    This should be a common application right
    Some hint will very helpful too
    Thanks in advance

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,936
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do you want to use VBA? Which combobox are you using - the one from the Control Toolbox or one from Forms? Is the data in one column or more?

    D

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want to use VBA, and I have 4 columns of data. So I guess I have to use 4 comboboxs.
    Can you help me out?
    Thanks in advance

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The purpose of my combobox is to show all the different data in a column and for user to type in the data. After the user has the data in the combobox, the user can search the data in the column.
    I have already done the search part. Right now, I just need the combobox to show all the data.
    Thanks in advance

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Location
    Leiden, The Netherlands
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    My suggestion would be to use the Advanced Filter in the Data menu to select unique items (select "Unique records only" and save results in a new location), and then to sort the resulting list. You can then use this list als input range for your combo box(es).

    Marc

  7. #7
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Allen

    I think this will be just what you need.

    http://www.ozgrid.com/VBA/UserForms.htm




  8. #8
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello Dave
    The example you have doesn't use the combobox and the user is not allow to type in the textbox.
    I found a couple of combobox examples, and I follow its instruction(basically, changing the property of the combobox). It is almost working now. The only problem I have is that it shows all the duplicated data and the scroll bar can't scroll.
    Can you help me out
    Thanks in advance

  9. #9
    Board Regular
    Join Date
    Feb 2002
    Location
    Ahmedabad Gujarat
    Posts
    303
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Friend,
    I suppose file nos.
    16,18,22,23

    if fact file nos 22 will give the help what exactly you are asking for and about showing the columns.. i suppose file nos 23 can be more useful to you.
    http://www.pexcel.com/download.htm
    from my download section can be helpful to you
    ni****h desai


    [ This Message was edited by: nisht on 2002-03-26 06:03 ]

  10. #10
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hello nisht
    I tried the examples you have but I still can't get my scroll bar move nor elimate the duplicated data. I downloaded file no.22, however, the file is damaged and I can't open it
    Any more help will be very appreciated
    Thanks in advance

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com